New field generated based on other fields data

[#1]

Hi,

I have data for a cashflow.

I have the client data with the value of the invoices and the value of the outstanding amount. I would like to genretate a new column that I would like to populate with two statements:

If the value is zero, I would like to populate with "Payed"

If the value is not zero I would like to populate with "Not payed"

Raw data:

Client_name, invoice_number, Value, Outstading_amount

xxx,  1234, 5500, 0

xxx,  1235, 2500, 2000

yyy,  3456, 8000, 5000

After imported I would like to have a table like this:

Client_name, invoice_number, Value, Outstading_amount, Status

xxx,  1234, 5500, 0       ,Payed

xxx,  1235, 2500, 2000  ,Not payed

yyy,  3456, 8000, 5000  ,Not payed

Thank you

[MayilVahanan]

HI

PFA

Hope it helps

[#3 · Accepted solution]

NewData:

Load Client_name,

         invoice_number,

        Value,

         If(Value<>0, 'Not payed', 'Payed') as NewValue,

        Outstading_amoun

From Table;

[#4]

Thank you