Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I create a calculated field from a calculated field in the same load statement?
LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],
[Invoiced Quantity]/[Size UOM] as [Result]
If (Match ( [Result], >1,000 ) , Accurate, Not Accurate) as [Position]
[Invoiced Quantity]/[Size UOM] as [Result]
If ( Invoiced Quantity]/[Size UOM] >1,000 ) , Accurate, Not Accurate) as [Position]
or use preceeding load:
LOAD
*,
If ( Result>1,000 ) , Accurate, Not Accurate) as [Position];
LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],
[Invoiced Quantity]/[Size UOM] as [Result]
[Invoiced Quantity]/[Size UOM] as [Result]
If ( Invoiced Quantity]/[Size UOM] >1,000 ) , Accurate, Not Accurate) as [Position]
or use preceeding load:
LOAD
*,
If ( Result>1,000 ) , Accurate, Not Accurate) as [Position];
LOAD
[Item No],
[Cost Amount]
[Sales Amount],
[Invoiced Quantity],
[Size UOM],
[Invoiced Quantity]/[Size UOM] as [Result]