Vlookup and create new value

[KirstenKa]

I am currently joining 2 datatables

C8:

LOAD

    " C8.sku"                       as %ItemColor_Tradingcode,

    " C8.sku"  as            ItemColor_Tradingcode,

Left Join( C8 )

SAP:

LOAD

   " SAP.Trading Co"                       as %ItemColor_Tradingcode,     

    " SAP.Trading Co"                      as ItemColor_ Tradingcode _SAP,

After that I would like to do a v-lookup to see if the value in SAP.Trading Co exists compared to C8.sku

If it doesn’t exist similar to yellow marked (Cell A2) I would like to mark the c8.sku as “not ready” in the following code in the load script

  If(num#([MovAv.4200],'#,00')<>0 AND num#("LSRP-4000",'#,00')<>0 AND trim([MovAv.4200]) & ''<>'' AND ("LSRP-4000")<>0 AND ([MovAv.4200])<>0 AND len(trim(Theme))*len(trim(MovAv.4200))*len(trim("CoO(Purcha"))*len(trim("LSRP-4000")), 'Ready', 'Not ready')  as SAPSFMSstatusSalesorder

Though the code above exists in the SAP upload table script and C8.sku exists in another upload script C8. How to adjust this code in the script?

[Or]

Try using Mapping Load instead of a left join. ApplyMap() will let you designate the result when no matching value is found.

[KirstenKa]

Thanks @Or the mapping load doesn't work in the script, probably a small thing

[Or]

That's not the correct syntax.

Map:

Mapping Load "Item ID", Article From SomeTable;

Load *, ApplyMap('Map',"Item ID",'Others') as Description;

Would fetch the Article for a given Item ID from the mapping load. Mapping loads should only have two fields.

[KirstenKa]

Sorry I did not see you added a link, I go try based on the description

[KirstenKa]

@Or I worked on the code. And I get the following error

This is my code  and attached a description of the values of the code. What goes wrong?