topic Re: Syntax of loaded fields is different in inline loads than resident loads in QlikView

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

julioarriaga — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Anil_Babu_Samineni — Mon, 07 Aug 2017 14:46:02 GMT

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

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

sunny_talwar — Mon, 07 Aug 2017 14:47:58 GMT

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.

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

justalkak — Thu, 01 Dec 2022 09:04:07 GMT

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