topic Re: Create new field then create another field based on new field in App Development

Create new field then create another field based on new field

rickrogers — Fri, 21 Dec 2018 20:16:16 GMT

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]

Re: Create new field then create another field based on new field

m_woolf — Fri, 21 Dec 2018 20:44:44 GMT

[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]