Lookup with condition between two sources.

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.

Conditional Lookup.yxmd

Workflow

Developer

Developer Tools

Accepted answers

RolandSchubert

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

Conditional Lookup_modified.yxmd

All comments

RolandSchubert

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

Conditional Lookup_modified.yxmd

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!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167