topic Generate a field in QlikView

Generate a field

AmCh — Sat, 23 Oct 2021 12:57:53 GMT

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

Re: Generate a field

squreshi — Sat, 23 Oct 2021 13:53:03 GMT

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