Set Analysis in LookUp Function

[#1]

What is the syntax to add set analysis to the below statement? I do not want the lookup feature to operate if [Delivery No.] = 'Result' . I'm not sure how to incorporate that into the syntax.

date#(WeekEnd(Lookup('Delivery_Date', 'Delivery_ID', [Delivery No.], 'Delivery_Date'), 0,2),'MM/DD/YYYY') as 'ActionDate'

Thank you for the help!

[Gysbert_Wassenaar · Accepted solution]

You can't use set analysis in the load script. You'll have to use an if-statement.