Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

RutiTaumanRubin
Contributor

Concatenate 3 fields to 1 row - Qlikview

Hi everyone.

I want to unite 3 fields to one row.

For example :

I have the following 3 fields:

ID1ID2ID3
114411
225522
336644

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.

3 Replies
OmarBenSalem
Esteemed Contributor

Re: Concatenate 3 fields to 1 row - Qlikview

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
Contributor III

Re: Concatenate 3 fields to 1 row - Qlikview

Hi,

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

MVP
MVP

Re: Concatenate 3 fields to 1 row - Qlikview

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)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser