topic Re: Create New Fields in the backend in QlikView

Create New Fields in the backend

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Create New Fields in the backend

ujjwalraja — Thu, 05 Jul 2018 07:31:00 GMT

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;

Re: Create New Fields in the backend

mahitham — Thu, 05 Jul 2018 07:44:36 GMT

Thanks for your help. Its working