Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sagarpawar
New Contributor III

Concatination

HI All,

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

 

Thanks,

Sagar

SGP
1 Solution

Accepted Solutions
MVP
MVP

Re: Concatination

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
MVP
MVP

Re: Concatination

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

sagarpawar
New Contributor III

Re: Concatination

Thank you Stefan:)

Its really helpful for learner ....

Thanks again

SGP
kamal001
New Contributor

Re: Concatination

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
New Contributor III

Re: Concatination

HI Kamal,

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

Thanks Again,

Sagar

SGP