topic Re: Combining tables in QlikView

Combining tables

Thu, 03 Nov 2016 13:28:33 GMT

What's the simplest way of doing this? Thank you in advance!

Table1:

Load * inline

[

A,B

1,'a'

1,'b'

1,'c'

2,'d'

3,'e'

3,'f'

];

Table2:

Load * inline

[

C,D

1,'g'

2,'h'

3,'i'

4,'j'

];

ResultTable:

Load * inline

[

E,F

1,'g a b c'

2,'h d'

3,'i e f'

4,'j'

];

Re: Combining tables

MarcoWedel — Thu, 03 Nov 2016 23:59:42 GMT

Hi,

one solution might be:

Table1:
Load * inline
[
A,B
1,'a'
1,'b'
1,'c'
2,'d'
3,'e'
3,'f'
];

Table2:
Load * inline
[
C,D
1,'g'
2,'h'
3,'i'
4,'j'
];

NoConcatenate

tabTemp:
LOAD C as A,
    D as B
Resident Table2;
Concatenate (tabTemp)
LOAD * Resident Table1;

ResultTable:
LOAD A as E,
    Concat(B,' ', RecNo()) as F
Resident tabTemp
Group By A;

DROP Tables Table1, Table2, tabTemp;

hope this helps

regards

Marco

Re: Combining tables

Fri, 04 Nov 2016 09:40:22 GMT

Worked perfectly! Thank you so much!

Re: Combining tables

MarcoWedel — Fri, 04 Nov 2016 18:56:23 GMT

You're welcome.

Nice to hear it helped

regards

Marco