Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
julioarriaga
Contributor 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

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

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

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

2 Replies

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

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

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

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

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.