Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
if(WildMatch(Notes, 'Regions*'), 'Regions Bank',
if(WildMatch(Notes, '*Suntrust*'), 'Suntrust Bank',
if(WildMatch(Notes, 'Redstone F*'), 'Redstone Federal Credit Union',
if(WildMatch(Notes, 'Family Security *'), 'Family Security Credit Union',
if(WildMatch(Notes, 'Community Spirit *'), 'Community Spirit Bank',
if(WildMatch(Notes, 'Valley Credit *'), 'Valley Credit Union',
if(WildMatch(Notes, 'Valley State *'), 'Valley State Bank',
if(WildMatch(Notes, 'First Metro *'), 'First Metro Bank',
if(WildMatch(Notes, 'BBVA *','BBVACompass*'), 'BBVA/Compass Bank',
if(WildMatch(Notes, 'BB and T *', 'BB&T *', 'BBT_*'), 'BB&T Bank',
if(WildMatch(Notes, 'Barclay Card*','Barclaycard*','Barclays Bank De Transfer*'), 'Barclays US',
if(WildMatch(Notes, 'Bank of the West*', 'Bankofthewest*'), 'Bank of the West',
if(WildMatch(Notes, 'Bank of Ozarks*','Bankoftheozarks*'), 'Bank of the Ozarks',
if(WildMatch(Notes, 'Lister Hill*', 'Listerhil*'), 'Listerhill Credit Union',
if(WildMatch(Notes, 'Bancorpsouth*'), 'BancorpSouth Bank',
if(WildMatch(Notes, 'Discover*'), 'Discover',
if(WildMatch(Notes, 'Ally*') and not WildMatch(Notes,'*Paypal*'),'Ally Bank',
if(WildMatch(Notes, 'Bank Independent*'), 'Bank Independent'))))))))))))))))))
Hi Mark. ApplyMap or Join could be much faster, but considering not a direct match there seems to be no a better alternative.