Question

Connector: Gsheet with Pigment

  • 26 April 2024
  • 4 replies
  • 83 views

Userlevel 1
Badge

Bonjour,

 

Je voudrais savoir si ce serait possible lors d’un extract de Pigment à Google sheet via le connector de ne pas avoir des lignes vides? Ex: Lors d’un extract avec le connector, j’ai 30.000 lignes et sur ses 30.000 lignes j’ai 10.000 lignes utilent et qui contiennent des valeurs. Cela alourdi énormément les fichiers de travail.

Dans les tables (extracts) dans Pigment, il y a une possibilité de filtrer et de mettre (Hide empty rows and columns). Ceci empêche d’avoir des milliers de lignes vides pas utiles.

Dans l’attente d’un retour, veuillez passer une belle journée :).

Cordialement.

TEGUA Jessica.


4 replies

Userlevel 5
Badge +8

Bonjour Jessica,

Le connecteur Google Sheets devrait correspondre à la vue, donc si vous masquez les lignes vides puis enregistrez la vue, lorsque vous extrayez cette vue, elle ne devrait pas inclure les lignes vides.

Je viens de retester cela moi-même pour confirmer. Si vous rencontrez des problèmes, je vous recommande de soumettre un ticket et nous pourrons examiner cela ensemble lors d'un appel.

Merci beaucoup.

Userlevel 1
Badge +2

Hi Jessica,

If I understand your request correctly, I have a workaround that should be applicable.

I simply create a table with the metric and filter to hide empty rows and columns, just as you did with the metric. Once this step is completed, you can built the export to Gsheet in the integration to point to this table and the data should come over as expected.

Hope this helps, please let me know if this does the trick!

 

Best,

Seth

Userlevel 1
Badge +2

Hi Jessica, 

This is an update to my previous message because my testing methodology was incomplete because I only had one metric in my rows. I tried this again with a table of 27 metrics in the rows and experienced the same issue. After opening an ticket and getting on a call with Pigment support, they said this was expected. When working with Metrics in a Table, the GSheet export functionality sees all Metrics as one and thus they either all show up or none of them do. The reason the support specialist gave as to why the view looks correct in Pigment and not GSheet is because there Google unfilters the metrics before bringing it in and doesn’t recognize the rows as being blank. It would be a good idea to submit to Pigment in the community to see if there could be a fix beyond filtering out the blank values.

Best,

Seth

Userlevel 1
Badge

Thanks all for your replies,
I did a ticket to Pigment customer support too to have a better comprehension. If a solution is found I will put it here.

Kind regards.

TEGUA Jessica.

Reply