Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have TABLE1, that has 3 fields : LETTER, WORD, LOOP
LETTER WORD LOOP
A Apple 2
B Ball 3
C Cat 1
What I am trying to generate is TABLE2 which looks like this:
LETTER WORD NEWFIELD
A Apple 2 Apple
A Apple 2 Apple
B Ball 3 Ball
B Ball 3 Ball
B Ball 3 Ball
C Cat 1 Cat
ie. the rows should get duplicated based on the value of LOOP.
Thanks,
Neeraj
Hi Neeraj,
Check the attached appliction.
Hope this helps you.
- Sridhar
Hi Neeraj,
Check the attached appliction.
Hope this helps you.
- Sridhar
Try this..
Table1:
Load * Inline [
F1, F2
1, B
2, D
3, R
];
Table2:
Concatenate
LOAD F1,F2,RowNo() as Id
Resident Table1;
Hi Sridhar, Jagan
Thank you very much for your inputs. I was able to resolve my issue.
Thanks,
Neeraj