This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Can someone help me out to How will I achieve below scenario?
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.