Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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';