Concatination

[sagarpawar]

HI All,

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

 

Thanks,

Sagar

[swuehl · Accepted solution]

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]

Thank you Stefan:)

Its really helpful for learner ....

Thanks again

[kamal001]

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]

HI Kamal,

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

Thanks Again,

Sagar