Join Problem

[reshmakala]

Hi All,

Attached is my QVW file. My amount values do not sum up as expected. Can anyone let me know what I am doing wrong?

[swuehl · Accepted solution]

Not quite sure what you want to achieve, but I assume the end of your script should look like

...

Result:

NOCONCATENATE

LOAD * Resident TEMP;

JOIN

LOAD * Resident FinalTable;

DROP TABLES FinalTable, TEMP;