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

[Anil_Babu_Samineni]

I am sure, There is no direct function for this

In Excel, We do have direct option like

Concatenate(Cell1 & "," & Cell2)

But qlikview has limited functionality.

[raajaswin]

Then I will go with Ifs only.. Thank u

[raajaswin]

Hi Every one,

Concat works fine, but I have a small problem kindly refer the attachment

[sunny_talwar · Accepted solution]

May be try this:

data:

CrossTable(TEXT, toto, 1)

LOAD * INLINE [

KEY, A, B,C

1, A, B,1

2, A, B

3, , B ,1

4, A, ,1

5

];

LOAD

KEY,

Concat(toto, ',', AutoNumber(TEXT)) as tt

Resident data

where len(toto)<>0

Group By KEY

;

[raajaswin]

Yo thats it. Thank you sunny