Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have a table like below
Table:
Load
%KEY,
External ID,
Type
From Partenr.qvd;
Here the Type field contains 3 records like TYPEA,TYPEB and TYPEC.
From above External ID and Type fields i have to create 3 fields i.e., TYPEA External ID, TYPEB Eternal ID, TYPEC External ID.
Please help me on this.
Thanks in advance
Hi Mahitha,
Use the following code.
Table:
Load *,
if(Type = 'TYPEA ', Type & '-' & External ID) as TYPEA External ID,
if(Type = 'TYPEB ', Type & '-' & External ID) as TYPEB External ID,
if(Type = 'TYPEC ', Type & '-' & External ID) as TYPEC External ID,
;
Load
%KEY,
External ID,
Type
From Partenr.qvd;
Hi Mahitha,
Use the following code.
Table:
Load *,
if(Type = 'TYPEA ', Type & '-' & External ID) as TYPEA External ID,
if(Type = 'TYPEB ', Type & '-' & External ID) as TYPEB External ID,
if(Type = 'TYPEC ', Type & '-' & External ID) as TYPEC External ID,
;
Load
%KEY,
External ID,
Type
From Partenr.qvd;
Thanks for your help. Its working