I need to join multiple columns with different names.

[#1]

Good afternoon,

I have a sistuação and need the help of Lords.

I need to join multiple columns with different names.

How to do this?


example:

Column A (data 1, 2.3)
Column B (figures 2,4,5)
Column C (data 6.7)
Column D (Data 😎


results
1
2
3
4
5
6
7
8


How to do this in a Load?

test:

A, B, C, D The Results
Resident Test;

[nagaiank · Accepted solution]

I used the following script to generate the result that you want.

Hope this helps.

Test:

LOAD * Inline [

A,B,C,D

1,2,6,8

2,4,7,

3,8,,

];

Result:

LOAD Distinct A as Result Resident Test Where (Len(A) > 0);

Concatenate LOAD Distinct B as Result Resident Test Where (Len(B) > 0);

Concatenate LOAD Distinct C as Result Resident Test Where (Len(C) > 0);

Concatenate LOAD Distinct D as Result Resident Test Where (Len(D) > 0);

[#3]

My colleague,

Thank you for your attempt to help.

I resolved my problem using the For command and Next

See the post below:

http://community.qlik.com/message/128861 # 128861

Either way thank you