Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarpawar
Contributor III
Contributor III

Concatination

HI All,

Can someone help me out to How will I achieve below scenario?

 

Thanks,

Sagar

SGP
1 Solution

Accepted Solutions
swuehl
MVP
MVP

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;

View solution in original post

4 Replies
swuehl
MVP
MVP

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;

sagarpawar
Contributor III
Contributor III
Author

Thank you Stefan:)

Its really helpful for learner ....

Thanks again

SGP
kamal001
Contributor
Contributor

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

sagarpawar
Contributor III
Contributor III
Author

HI Kamal,

Thanks for help. Will try with this option will update the same.

Thanks Again,

Sagar

SGP