topic Re: Combining Records in QlikView

Combining Records

Thu, 14 May 2015 16:10:48 GMT

From the following script:

LOAD A,
C,

D
FROM
QVDs\SOURCE1.qvd (qvd)

LOAD A,
B
FROM
QVDs\SOURCE2.qvd (qvd)

I get this result:

I would also like to display the records in B in this way:

There are differing quantities of records in B for each one in A. Is it possible to load this in both ways?

Message was edited by: Jason Noltee

Re: Combining Records

Gysbert_Wassenaar — Thu, 14 May 2015 16:38:38 GMT

That's interesting. Since you only load field B from source2.qvd the tables will have no fields in common. So I'd expect a cartesian product instead of the result you posted. You can try creating a straight table with concat(B, ' / ') as expression for column E.

Re: Combining Records

Thu, 14 May 2015 17:19:58 GMT

I apologize. I edited to show A loaded from source2 also.

Re: Combining Records

Anonymous — Thu, 14 May 2015 17:26:13 GMT

In this case the solution from Gysbert (concat) is correct. You can use it on the front end or in the script.

Re: Combining Records

Thu, 14 May 2015 18:24:07 GMT

This is the result:

A	E	C	D
123	Record 1 / Record 2 / Record 3 / Record 4	100	200
321	Record 1 / Record 2 / Record 3 / Record 4	200	300

It should be:

A	E	C	D
123	Record 1 / Record 2	100	200
321	Record 3 / Record 4	200	300

Re: Combining Records

Thu, 14 May 2015 18:38:40 GMT

TRY THIS IS SCRIPT

LOAD A, Concat(B,'/') AS E
GROUP BY A;

Hope this helps

Re: Combining Records

Thu, 14 May 2015 18:44:31 GMT

Adding this worked perfectly. Thank you.