This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to update fields by the largest string counts. The sample data is following:
In this case, string count "75" is the largest number. Therefore, I would like to update Specialty field to "Allopathic & Osteopathic Physicians|Internal Medicine|Transplant Hepatology".
I was trying to use the Multi-Row formula. I could only update one row, but not all rows.
I would appreciate if there is any suggestions.
Go to Solution.
Go to Solution.
I love the Multi_row formula tool but I didn't use it here.
I SORT the records so the highest count was the first record.
Then I used the SELECT RECORDS tool to get just the first record (because the S.R. tool doesn't get much love)
Then I APPEND FIELDS to add the specialty name of the longest string to each record
Then I use SELECT to drop the original specialty and rename the longest specialty
Thank you for your reply. This is good when I have only one name. Sorry that I didn't tell you that I have more than one name. For example, I have 3 names: Apple, Banana, and Orange.
In this case, the desired output is following:
I think the select record tool does not work for this particular example. Is there any way to filter out the largest Specialty String Count per person so that I can append later on like you did?
I think I figured it out!
Thank you for your help.