Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm receiving an error in the Data Load Editor, "Invalid Expression". I believe it's due to how I've formatted the 2nd formula (alias 'RO'), but I can't figure out how to resolve the issue.
LOAD
Hi, perhaps something like this
LOAD Field1,
Field2,
Sum(If(ALD_auth_qty>0, ALD_auth_qty + (amds_auth_qty + namds_auth_qty + wisds_auth_qty) + hpmsk_deployed_qty, (total_demand_level + spds_on_hand_qty) + (amds_auth_qty + namds_auth_qty + wisds_auth_qty) + (hpmsk_auth_qty)) ) as RO
Resident YourSourceTable
Group By Field1, Field2;