Newfield Creation for Same Field name

[pradeep92]

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.

[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]

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