New data column added when loading the raw table

[#1]

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

[Sokkorn]

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

[johnw · Accepted solution]

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

;

[#4]

Thanks John, problem solved.