I'm working on transaction data to find customer paying competitors. The data isn't straight forward, so I've had to find common characteristics that I can match on to decipher who the payment is going too. This has led to a moderately long if statement with more needing added. I need a better alternative as with this being transaction data includes millions of lines of data, thus with the If Statements makes it even slower and clunkier. Thanks!
Finally was able to open and this works great! I actually have 6 variables I'm using in place of ifStatements and/or pick(match()). Everything works correctly and I did see some performance increase. Unfortunately I'm loading 7-8 million row and then doing an aggr calculation on that table which ends up being around 6 million rows, so it does take longer than I would like to load. I've also noticed on my dashboards that where I'm using more granular data that it takes much longer to load. Does anyone have any suggestions? I would like to improve this, as I'm only pulling 6 months worth of data and would like to ramp that up to a rolling 12. Thanks everyone for your help!