How add prefix for a field in a table in Qlik sense Script.

[Kalyani22]

I have data like this.

Plant code, Company code.

001, 7002

Now I want to add prefix for this code.

Output:

Plant code, Company code.

ICE/001, ICE/7002

[Clement15]

Hello, you can do this in your script:

Table:

Load

'ICE/'&[Plant code] as [Plant code],

'ICE/'&[Company code] as [Company code]

From x ;

[Nicolae_Alecu]

Hello, 

You can use this:

set vPrefix = 'ICE\';

Load 
vPrefix&[Plant code] as [Plant code],
vPrefix&[Company code] as [Company code]

[camilasophia697 · Accepted solution]

To add a prefix to a field in a table in Qlik Sense script, you can use the CONCATENATE function. Here's a short example:

LOAD
'ICE/' & [Plant code] AS [Plant code],
'ICE/' & [Company code] AS [Company code]
FROM
YourDataSource;

This script will load the data from your data source and concatenate 'ICE/' with the values of the Plant code and Company code fields, creating the desired output with the prefix added.