Syntax of loaded fields is different in inline loads than resident loads

[julioarriaga]

Hi all,

This is a question of curiosity. Why fields with spaces can be written without [ ] in an inline statement and in a resident load, for example, that is not possible?

Image 1: Shows the syntax error using [ ], in an inline load.

Image 2: Shows a correct statement in an line load not using [] and a correct resident load using [].

Thanks and regards.

(Image 1) Incorrect

(Image 2) Correct

[Anil_Babu_Samineni · Accepted solution]

By using simple inline memory don't require Square brackets for consumption. If you are doing Resident / Loading / Preceding you must need [] for space fields because QIX engine cannot understand the Which is the field wither A or nor Stat. So then we are making them understand to Qlik easily called Field like [A Stat]

HTH

Anil

[sunny_talwar]

It is just how the syntax is built... you don't really need to group the field names in Inline Load because it expects to see spaces and only consider a new field name to begin after your delimiter. When not specified otherwise, delimiter is a comma.

[justalkak]

Hi,

do you have any suggestion how I should put field example : Rate Increase [%] in the inline load? How to make it work with the square brackets in the field name?

Thanks