Create new column in load script

[KirstenKa]

In the load script I would like to add a new column which check 4 columns to see if there is a value or an empty value, if value in all 4 columns, then “ready” is added in the row, if no value in 1 of the 4 columns then “not ready”

[tealowk · Accepted solution]

Hi Kristen,

it seems that you are trying to sum over the Status field. Please try the count function.

E.g. count([SAP.SAPSFMSstatusSalesOrder])

Kind regards from Brussels,

Thilo

[PrashantSangle · Accepted solution]

Hi @KirstenKa ,

you are doing sum of text? and you are looking for count of records.

So, instead of SUM() use count()

Regards,

Prashant Sangle

[Oleg_Troyansky · Accepted solution]

Hi Kirsten,

As the other guys suggested, you should be counting the statuses using the function count().

Cheers,

[KirstenKa · Accepted solution]

It works thanks

[KirstenKa]

It works thanks

[KirstenKa]

It works thanks

[KirstenKa]

It works thanks