Load Inline

[marco_puccetti]

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

[Digvijay_Singh]

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

[rubenmarin]

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.

[pokassov]

Hi!

These are 2 different fields

[MK_QSL]

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..

[Anonymous]

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

[marco_puccetti]

What do you mean for system field?

Thanks

Marco

[rubenmarin]

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'