Discussion board where members can get started with Qlik Sense.
Hi, I am trying to drop fields while also renaming. All the fields I do not want are renamed as numbers, I tried to create an if statement that would drop the unwanted fields but it is not working. Let me know if anyone has any ideas!
Here is my script:
(ooxml, embedded labels, table is Initiative__c)
Rename Fields using Initiative__c;
May be this
WHERE len(Rename)>0 and IsText(Field);
it is still showing the fields, it must be reading the numbers as text.
I can also change the names in the field map if that helpful
How about this?
WHERE len(Rename)>0 and not IsNum(Num#(Field));