topic Re: New data column added when loading the raw table in QlikView

New data column added when loading the raw table

Mon, 12 Dec 2011 23:04:08 GMT

Hi people,

I would like to add a new cloumn, which is based on the data loaded, when loading the data - Say, the raw table looks like:

Number
1
2
3
4
5
6
7
8
9
10

I want to have another column, if bitand 3 = 3, added to the table so that the raw data table could be like

Number	Bitand3
1	NO
2	NO
3	YES
4	NO
5	NO
6	NO
7	YES
8	NO
9	NO
10	NO

In order to get that, how should I change the loading setting correspondingly?

Thanks in advance!

Thomas

New data column added when loading the raw table

Sokkorn — Tue, 13 Dec 2011 01:03:07 GMT

Hi Thomas,

Can you give more data source? Your raw table is only one column so it difficult to understand data source. Thus we need raw table (at lease 3 column), condition and the result that you need.

Regards,

Sokkorn Cheav

Re: New data column added when loading the raw table

johnw — Tue, 13 Dec 2011 01:49:23 GMT

LOAD

Number

,if(Number bitand 3 = 3,'YES','NO') as Bitand3

;

// your real data source should replace the below

LOAD recno() as Number

AUTOGENERATE 10

;

Re: New data column added when loading the raw table

Wed, 14 Dec 2011 20:37:40 GMT

Thanks John, problem solved.