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

I need to join multiple columns with different names.

Wed, 29 Jun 2011 17:38:24 GMT

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;

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

nagaiank — Wed, 29 Jun 2011 17:53:04 GMT

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

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

Thu, 30 Jun 2011 12:24:44 GMT

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