Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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);
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);
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