Concat on two generic fields

[TomBond77]

Hi experts

[0COSTCENTER] as [Acc. Cost Center ID],

[0COSTCENTER__TEXT] as [Acc. Cost Center Text],

[Acc.  Cost Center Text] & '' & [Acc. Cost Center ID] as [Acc. Cost Center],

The last line is not accepted, Qlik don't know this field. How can we solve this issue?

Thanks.

Tom

[Mauritz_SA]

Hi Tom

When you reference a field in the script it should have the same name as in the source. The fields will only have their new names in the resulting (resident) table. In your case you should be able to use:

[0COSTCENTER] as [Acc. Cost Center ID],

[0COSTCENTER__TEXT] as [Acc. Cost Center Text],

[0COSTCENTER__TEXT] & [0COSTCENTER] as [Acc. Cost Center],

There is also not a need to add the '' unless you want to put a certain character in there like an underscore & '_' &.

Regards,

Mauritz