If.....where

[#1]

Hi,

I have table bellow, the code for CCC is empty, my need is : if type is '3', then show code of  the same customer where type is 1 as code of CCC.

CUSTOMER	NAME	TYPE	CODE
FFF	AAA	1	101
FFF	AAA	1	102
FFF	BBB	2	202
FFF	CCC	3
FFF	AAA	1	103

The final table will be like bellow

CUSTOMER	NAME	TYPE	CODE
FFF	AAA	1	101
FFF	AAA	1	102
FFF	BBB	2	202
FFF	CCC	3	101
FFF	CCC	3	102
FFF	CCC	3	103
FFF	AAA	1	103

how to proceed?

[jagan]

Hi,

Try like this

Data:

LOAD

     CUSTOMER,

     NAME,

     TYPE

     IF(TYPE= 3, '103', CODE) AS CODE

FROM DataSource;

Regards,

Jagan.