Forum Discussion
Partial match from 3 column with text
Please remember to @ when replying. Otherwise we do not get notified of your response.
If this is coming from a SQL source, I think that would be where you would want to perform something with the complexity of 200 individual texts and 14 columns.
Other option is to split your Delimiter into rows rather than columns.
On the Delimiter, selecting "advance options" gives you the option of rows vs columns.
For example, Record X 11 would have 200 corresponding rows.
You can Concatenate each of your 14 Columns together into fewer columns - whatever character limitations you might bump up against.
Then create a Match column that looks to find each row of text in these new Concatenated columns.
Still a little cumbersome, but better deal with fewer columns and many rows than the other way around.
Regards,
Community ChampionPlease remember to @ when replying. Otherwise we do not get notified of your response.
If this is coming from a SQL source, I think that would be where you would want to perform something with the complexity of 200 individual texts and 14 columns.
Other option is to split your Delimiter into rows rather than columns.
On the Delimiter, selecting "advance options" gives you the option of rows vs columns.
For example, Record X 11 would have 200 corresponding rows.
You can Concatenate each of your 14 Columns together into fewer columns - whatever character limitations you might bump up against.
Then create a Match column that looks to find each row of text in these new Concatenated columns.
Still a little cumbersome, but better deal with fewer columns and many rows than the other way around.
Regards,
rsbin thank you, it works great with rows 🙂