pradeep92
Partner - Creator II
2019-03-27
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
395 Views
2 Replies
sunny_talwar
MVP
2019-03-27
07:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
392 Views
raman_rastogi
Partner - Creator III
2019-03-27
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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';
385 Views