Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
I don't see how this would be possible in the expression, you should do it in the script.
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)