Vlookup

[KirstenKa]

After a join I would 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

[cristianj23a]

Hello, I do not understand your question, could you give me more detail.

[KirstenKa]

@cristianj23a  still working on the code, will give you an update once I can clarify my question better

[KirstenKa]

@cristianj23a  I wrote an explanation of this issue in a new post here:     https://community.qlik.com/t5/New-to-Qlik-Sense/Add-Vlookup-result-to-column-complicated-issue/m-p/2...

[cristianj23a]

Hello, ok now I see it