Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, i need some help with this:
I have an Inline table with these fields:
Div,Account, Sub-Account, Year, Month, Variable.
And another QVD with these fields:
Div,Account, Sub-Account, Year, Month, Sales
I need to do a join or something else, i need to multiply the sales to variable on the script and put the results in other table.
Does anyone can help me with this issue???
Regards
Orlando
Hi Orlando,
You can left join the QVD to the first inline table so that you will get the variable and sales in same row and then you can multiple in the next resident load table.
regards
rajesh