CSV Tempate behaviour

I’m trying to get a CSV template to work by creating a TXT file and uploading to Google Drive. So this one works fine:

<<START: Select(Skips[SkipID],TRUE)>>

but it displays lots of blank rows so changed to:

<<START: Select(Skips[SkipID],ISNOTBLANK([SkipID]))>>

Which made no difference whatsoever… So I tried:

<<START: Select(Skips[SkipID],[Status]=”Dropped”)>>

Which doesn’t display any rows despite there being “Dropped” in dozens of the [Status] column.

Where am I going wrong? Do I need to point the template at a slice to get a filtered view?

0 1 189
1 REPLY 1
Top Labels in this Space