Generate a field

[AmCh]

Hi all,

I have as an example the following table in excel to load:

a	b	c	d
1	1	0	3
2	1	0
3	1
4

I want to load this table an to create new field DRIVER to it such that:

DRIVER	a	b	c	d
MAIN	1	1	0	3
MAIN	2	1	0
MAIN	3	1
MAIN	4

How can I do it?

Thanks in advance

[squreshi · Accepted solution]

Hi Amch,

Add a Driver column in your script with value as 'Main'.

You can use the below script to do the same.

LOAD 'Main' as Driver, // Add Column in the Load with 'Main' as static value
             a,
             b,
             c, 
             d
FROM
[C:\Users\hp\Desktop\QlikCommunityData.xlsx]
(ooxml, embedded labels, table is Data3);

Please mark it correct, if you find it useful.

Cheers !
Squeshi