Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL
Hope all is good.
I am using Magic ETL and trying to create a flow replicating the current logic of my Excel file.
In Excel I have 2 datasets. On the Main sheet a column is categorizing using the formula =IFERROR(VLOOKUP(value,range,exact Match),IF(RIGHT(Category,2)="AB","Above","Below))
Now in Magic ETL data flow, I used Left outer join then I connected it to add formula, the formula I wrote: CASE WHEN (`Category`= null OR `Category` = '') AND RIGHT(TRIM(`Product Group name`),2)='AB' THEN 'Above' ELSE 'Below' END
But the output of the flow does not match on what is in my excel, the formula is superseded the left outer join.
Thank you All,
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部