Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
pradeep92
Partner - Creator II
Partner - Creator II

Newfield Creation for Same Field name

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.

 

2 Replies
sunny_talwar

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';
raman_rastogi
Partner - Creator III
Partner - Creator III

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';