I'm trying to combine 2 different qvd's into one table. Here is what I have.
INVOICE: LOAD hdr_key, entity as [entity code], [cash discount amt] as [amount], [cash discount gl account] as [gl account] FROM $(vPathNameLayer1)inc-hdr-all.qvd(qvd);
JOIN LOAD hdr_key, line_key, [line gpsa] as [amount], [line item gl account] as [gl account] FROM $(vPathNameLayer1)inc-line-all.qvd(qvd);
When I do this then entity code is not showing up for anything from the second join. How do I accomplish this? Here is what I would do in SQL but it doesn't like the syntax.
JOIN
LOAD
hdr_key,
entity as [entity code],
line_key,
[line gpsa] as [amount],
[line item gl account] as [gl account]
FROM $(vPathNameLayer1)inc-line-all.qvd(qvd) as a,
