Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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';
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';