Combining Records

[#1]

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

[Gysbert_Wassenaar]

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.

[#3]

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

[Anonymous]

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

[#5]

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

[#6 · Accepted solution]

TRY THIS IS SCRIPT

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

Hope this helps

[#7]

Adding this worked perfectly.  Thank you.