Lookup with condition between two sources.

[RichardAlt]

Hi guys,

I have a simple problem in lookup with condition.

I have 2 sources lookup is working fine, but when the "Table 1" has null value in "Reimbursement Column" it's not getting the currency in "Table 2", I need a condition when if "Reimbursement Currency" is null, I need to lookup the payment type to "Table 2" and get the currency.

I've attached my sample workflow.

Any ideas, I'm getting 0 value by the way.

Sorry for my bad English.

.

[RolandSchubert · Accepted solution]

Hi @RichardAlt ,

I've modified your workflow a bit. I think, using a Join tool could be used to match the "default currency" from Table 2 to the payments in Table 1. In addition, I've changed the formula a bit. 

Let me know if it works for you.

Best,

Roland

[RichardAlt]

@RolandSchubert ,

Yes this will work, But when I moved the tools to original workflow it will multiply the data 10x or more than that. Can I use union tool instead of Join tool, Please advise, Thanks!

[RolandSchubert]

Okay, I guess, "Payment Type" is not unique in "Table 2". The Find Replace tool may be the better choice, it will select the last currency for a payment type in Table 2 (this may be the most recent one).

The Union tool will not work, as it will append table 2 to table 1. I've changed the workflow to use Find Replace tool. Give i a try and let me know if it works.

Best,

Roland