Change the Number In Negative

[KC3]

Hi All,

Please help to change the return number in negative.

I applied If(type='Refund',quantity*-1,[quantity]) as Net_Qty,  in Script but not getting the right output

Below are the fields

"type",
"order id",
Sku,
description,
quantity,

These are the data i need as output

type	quantity	Output Data
Refund	1	-1
Order	1	1
Service Fee	1	1
Adjustment	1	1
Fulfilment Fee Refund	1	1
FBA Inventory Fee	1	1
Tax Withheld	1	1
Transfer	1	1

[Taoufiq_Zarra · Accepted solution]

@KC3  the syntax is good

this in load script:

LOAD *,if(type='Refund',-1*quantity,quantity) as Net_Qty  INLINE [
    type , quantity
    Refund ,1
    Order ,1
    Service Fee ,1
    Adjustment ,1
    Fulfilment Fee Refund ,1
    FBA Inventory Fee,1
    Tax Withheld,1
    Transfer,1
];

output:

[Taoufiq_Zarra]

[KC3]

Hi,

Not getting it properly

Having  Syn error

PFB image for your refrence

[Taoufiq_Zarra]

@KC3 

you need to use it in your load script 

Inline ... is an example

you need :

load
"date/time",
if(type='Refund',-1*quantity,quantity) as Net_Qty,
... otherfield

From ...

[KC3]

tried this but i am not getting this 

first i tried that only

SCript

OUTPUT

[Taoufiq_Zarra]

@KC3 can you elaborate

its correct your output

or can you share the expected output ?