Hi everyone,
I need some help with a problem.
I have a column of concatenated strings, which are 1+ items, likely not more than 15 in one record. Then I have other lists of strings. These lists are all combinations of only 2 items, concatenated with 2 possible combinations. All the items correspond to a number and the numbers can be a concatenated form or in columns. When I join the larger list to the smaller lists, it does not yield results due to the fact that the concatenated values in the smaller lists are only 2 items and some of the combinations in the larger list are not only 2 items, but can vary from 1 or more.
The larger list of strings can change (the smaller lists of strings also change) for various situations, and so the solution cannot be cannot be only for the example I share, but needs to be applicable in general.
I need to find a way to get the correct receipt numbers joined back to the smaller lists. I.e. if a record in the larger list contains "av,extent,cab,ar.net" then it needs to match with "cab,extent" OR "extent,cab" If the smaller list is "alt,ar.net" or "ar.net,alt" then it needs to match with all the records named "ar.net,ls.ut,alt" and "alt,cab,ar.net" in the larger list. The smaller list must match with all the records that contains the substring in the larger list. The unique tool can then be used at the end to get the unique receipt numbers with the specific concatenated string.
The code numbers correspond to the item 1 item item 3 etc in the concatenated list of items.
Thank you for your time and help!
Updated the flow - there was a mistake.
Rouche
