Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a script consisting of several joins. I want to add a calculated field in the end, where I devide the value of 2 fields. My problem is that when deviding the key field is not taken into account. See attached file.
I would expect a result with 3 rows - one row for each article. Please help.
I think you need to use the Article field in your last left join:
left join (Data)
load Article,
Qty/BoxSize as NumberBoxes
Resident Data;
I think you need to use the Article field in your last left join:
left join (Data)
load Article,
Qty/BoxSize as NumberBoxes
Resident Data;
Use resident load, see attached