Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
TRY THIS IS SCRIPT
LOAD A, Concat(B,'/') AS E
GROUP BY A;
Hope this helps
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.
I apologize. I edited to show A loaded from source2 also.
In this case the solution from Gysbert (concat) is correct. You can use it on the front end or in the script.
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 |
TRY THIS IS SCRIPT
LOAD A, Concat(B,'/') AS E
GROUP BY A;
Hope this helps
Adding this worked perfectly. Thank you.