I'm working with connecting a dashboard to SFDC data and it all works fine except that I have pull in data for which the field name is "Type". In QlikSense script editor this is automatically recognized as a command/keyword so it won't load. I've tried putting the word in various types of quotation marks, parentheses etc but I can't get it to work.
Please help? What is the correct syntax that would allow me to load in this data also?
Try using the alias with your first select statement:
Type as `Campaign Type`,
. . . . .
Thanks and Regards,
Within the qlik sense part are square-brackets working for me - [Date] for example won't be highlighted but even without them worked the load-statement which meant Date wouldn't be handled as keyword or function else simply as field (the syntax interpreter isn't always correct).
Thanks for your help.
I feel foolish but I think it actually works just as it is. Although the word is "flagged" as a script command it actually works. I just assumed it was not working and tried all kinds of different variations to no avail.
Again, thanks for jumping in to help.