I need to identify all transactions involving certain companies in a dataset. Since the names on my company list won't exactly match the names in the transaction dataset, I plan to identify variations using @similarphrase. I have over 100 companies to search for in the dataset so I am trying to define an array containing the 100 companies and create a loop so that the @similarphrase function is performed on all 100 names. I would need the output to be a separate column for each company name. I am fairly new to IDEAScript and am having trouble getting this to work. Any help would be appreciated.
Last seen: 1 year 8 months ago
Joined: 10/20/2017 - 15:44