Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

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

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

Capture1.PNG

(Image 2) Correct

Capture2.PNG

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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
Partner - Contributor III
Partner - Contributor III

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