Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
Can someone help me out to How will I achieve below scenario?
Thanks,
Sagar
INPUT:
LOAD
Number, Recno() as RecID, Name
FROM ActualDataTable;
Result:
LOAD Number,
Concat(Name, ' ', RecID) as Name
RESIDENT INPUT
GROUP BY Number;
DROP TABLE INPUT;
INPUT:
LOAD
Number, Recno() as RecID, Name
FROM ActualDataTable;
Result:
LOAD Number,
Concat(Name, ' ', RecID) as Name
RESIDENT INPUT
GROUP BY Number;
DROP TABLE INPUT;
Thank you Stefan:)
Its really helpful for learner ....
Thanks again
Hello Sagar,
Please follow as below.
Step 1: Create Excel Table Concatenate.xls same as with two columns Number and Name
Step 2: Script will be as below
Concatination:
LOAD Number,
Name
FROM
(ooxml, embedded labels, table is Sheet1);
Final_Concatination:
load Distinct Number,
Concat(Name,' ') as NewName
resident Concatination
Group by Number;
Step 2: save and re-Load the script
Step 3 : Check by creating table box object ( use Final_Concatination )
Thats all !
Hope this will help you !
Kamal Bhalla
HI Kamal,
Thanks for help. Will try with this option will update the same.
Thanks Again,
Sagar