Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

I need to join multiple columns with different names.

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 8)


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;

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: I need to join multiple columns with different names.

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);

2 Replies
nagaiank
Valued Contributor III

Re: I need to join multiple columns with different names.

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);

Not applicable

Re: I need to join multiple columns with different names.

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