topic Newfield Creation for Same Field name in QlikView

Newfield Creation for Same Field name

pradeep92 — Wed, 27 Mar 2019 11:30:07 GMT

Hi, I have a table with data as below,

load * inline [

A,B,C

Arun,100,CD

Arjun,80,CD1

Jinu,60,CD2

Ram,90,CD

];

Desired output :

A,B,C

[

Arun,100,CD

Arjun,80,CD1

Jinu,60,CD2

Ram,90,CD

Arun,100,CDNE

Ram,90,CDNE

];

How to get the desired 2 records which falls under CD has to come under new CDNE also.

Re: Newfield Creation for Same Field name

sunny_talwar — Wed, 27 Mar 2019 11:40:06 GMT

May be this

Table:
LOAD * INLINE [
A,B,C
Arun,100,CD
Arjun,80,CD1
Jinu,60,CD2
Ram,90,CD
];

Concatenate (Table)
LOAD A,
  B,
  'CDNE' as C
Resident Table
Where C = 'CD';

Re: Newfield Creation for Same Field name

raman_rastogi — Wed, 27 Mar 2019 11:38:41 GMT

try this

T1:
load * inline [
A,B,C
Arun,100,CD
Arjun,80,CD1
Jinu,60,CD2
Ram,90,CD
];
Concatenate
Load A,
B,
C&'NE' as C
Resident T1 where C='CD';