Concat using dynamic string

[raajaswin]

Hi all,

My Input,

KEY	TEXT1	TEXT2
1	A	B
2	A	B
3		B
4	A
5

Required Output,

KEY	OUTPUT
1	A,B
2	A,B
3	B
4	A
5

Need to do it in script,

As of now am using some nested if and & operator, do we have direct function??, can we do it with concat??

[swuehl]

You can transform your input table using CROSSTABLE LOAD prefix into a table with structure KEY, TEXT, and TEXT ID, then aggregate (using Concat() ) this new table TEXT values Grouped by KEY.

The Crosstable Load

[raajaswin]

if(isnull(TEXT1),TEXT2,if(isnull(TEXT2),TEXT1,TEXT1&','&TEXT2))

this is what am doing as of now

[raajaswin]

i have many more columns and lakhs of rows like this,  I dont think cross table can be formed for this

[Aurelien_Martinez]

Hi,

If you have more than one field change the number 1

data:
CrossTable(TEXT, toto, 1)
LOAD * INLINE [
KEY, TEXT1, TEXT2
1, A, B
2, A, B
3, , B
4, A
5
];


LOAD
KEY,
Concat(toto, ', ') as tt
Resident data
Where Len(toto)<>0
Group By KEY
;

[sunny_talwar]

So what is the issue with this? This isn't working?

[Anil_Babu_Samineni]

Does this working same as this from Preceding Load

(Text1 & ',' & Text2) as Output

[raajaswin]

Am looking for any direct function.. I will try out this way and let u know.. Thank u

[raajaswin]

This will give me an additional comma, when Text 2 is blank

[raajaswin]

Ya what i was doing is crct nly,, Just wanted to know is there any direct fuction for this??