topic Re: Concatination in QlikView

Concatination

sagarpawar — Wed, 24 Oct 2018 10:16:14 GMT

HI All,

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

Thanks,

Sagar

Re: Concatination

swuehl — Wed, 24 Oct 2018 10:20:16 GMT

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;

Re: Concatination

sagarpawar — Wed, 24 Oct 2018 10:27:58 GMT

Thank you Stefan:)

Its really helpful for learner ....

Thanks again

Re: Concatination

kamal001 — Wed, 24 Oct 2018 10:39:53 GMT

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

Re: Concatination

sagarpawar — Thu, 25 Oct 2018 05:18:43 GMT

HI Kamal,

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

Thanks Again,

Sagar