2 different lookups in if statement.

[sumarri]

When I search I want something like this:

if(ID =99): then lookup 1,

else: lookup 2.

What I have right now is something like this, but I done know how to put it in the correct syntax: 

| eval To_AccountID= if(ID="99",
[search | lookup Payroll1.csv PARENTACCOUNT OUTPUT Product_Type as To_AccountID, AccountType as To_Account],
[search | lookup Payroll2.csv PARENTACCOUNT, ID as PARENTID OUTPUT TYPE as To_AccountID, AccountType as To_Account])

What is the best way to code something like this??? 

[ITWhisperer · Accepted solution]

SPL is not a procedural language and does not have if...then...else... constructs

Try something like this

| lookup Payroll1.csv PARENTACCOUNT OUTPUT Product_Type as To_AccountID_99, AccountType as To_Account_99
| lookup Payroll2.csv PARENTACCOUNT, ID as PARENTID OUTPUT TYPE as To_AccountID_NOT_99, AccountType as To_Account_NOT_99
| eval To_AccountID= if(ID="99",To_AccountID_99,To_AccountID_NOT_99)

[sumarri]

That is what I ended up doing, but I want to know if there was another way like that! Looks like it is the only way...

Thank you!