topic Re: Load Inline in QlikView

Load Inline

marco_puccetti — Fri, 02 Oct 2015 10:13:18 GMT

Hello what's the difference between

Table:

LOAD * INLINE [

#A, B

C, D

E, F

G, H

];

and

Table:

LOAD * INLINE [

A, B

C, D

E, F

G, H

];

With and without '#'??

Thanks

Marco

Re: Load Inline

Digvijay_Singh — Fri, 02 Oct 2015 10:20:18 GMT

I think only field name would be different either A or #A based on what is used. Don't see any other difference

Re: Load Inline

rubenmarin — Fri, 02 Oct 2015 10:21:54 GMT

Hi Marco, I think it only changes the name of the field, in the first table is called '#A' and in the second table is called 'A'.

If you use HidePrefix = '#'; then the field of the first table is tagged as a system field.

Re: Load Inline

pokassov — Fri, 02 Oct 2015 10:22:44 GMT

Hi!

These are 2 different fields

Re: Load Inline

MK_QSL — Fri, 02 Oct 2015 10:28:44 GMT

The data model would be with tow tables.

Table and Table-1

Both the tables would be associated by field B

A and #A are two different fields..

Re: Load Inline

Anonymous — Fri, 02 Oct 2015 10:40:13 GMT

Hi Marco,

A(Table) and #A(Table) are two different fields from both tables.

is Set HidePrefix = '#'; present in script.

So,Usually loading data from complex data sources there are fields in the data model that are required to be extracted in that you do not want to be visible to the end users. We may just want them to treat the fields like System Fields.

This can be achieved by a System Variable named “HidePrefix”. Using this we can make our own fields visible or not.

Regards

Neetha

Re: Load Inline

marco_puccetti — Fri, 02 Oct 2015 10:53:59 GMT

What do you mean for system field?

Thanks

Marco

Re: Load Inline

rubenmarin — Fri, 02 Oct 2015 11:03:15 GMT

Hi Marco, it's a property of the fields, if is taggeds as system field it will not show on 'Current Selections' and only will show listed when you check 'Show System Fields'