Discussion Board for collaboration related to QlikView App Development.
Can someone help me out to How will I achieve below scenario?
Go to Solution.
Number, Recno() as RecID, Name
Concat(Name, ' ', RecID) as Name
GROUP BY Number;
DROP TABLE INPUT;
View solution in original post
Thank you Stefan:)
Its really helpful for learner ....
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
(ooxml, embedded labels, table is Sheet1);
load Distinct Number,
Concat(Name,' ') as NewName
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 !
Thanks for help. Will try with this option will update the same.