Concatenate 3 fields to 1 row - Qlikview

[RutiTaumanRubin]

Hi everyone.

I want to unite 3 fields to one row.

For example :

I have the following 3 fields:

ID1	ID2	ID3
11	44	11
22	55	22
33	66	44

I want that after the calculated I will get 1 row with all the united values:

ID
11
22
33
44
55
66

I prefer the calculated will be in the edit expression and not in the script...

Any advise?

Than you!

Ruti.

[OmarBenSalem]

I can see that done only in the script by using the crossTable and load distinct...

Can't see how it would be possible in the expression editor.

[niclaz79]

Hi,

I don't see how this would be possible in the expression, you should do it in the script.

[jonathandienst]

Not easy or practical to do in expression - much better in script.

LOAD ID1 as ID

FROM Source;

Concatenate

LOAD ID2 as ID

FROM Source

Where Not Exists(ID, ID2)

Concatenate

LOAD ID3 as ID

FROM Source

Where Not Exists(ID, ID3)