Create New Fields in the backend

[mahitham]

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

[ujjwalraja · Accepted solution]

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;

[mahitham]

Thanks for your help. Its working