Replacing multiple columns of text strings with new columns of text strings. Text strings vary from single word to six words for each string. There are hundreds of these text descriptions throughout 40 columns.
Obviously, Dictionary Replacer fails as it can only replace one column at a time, and I cannot make it work on multi-length word text descriptions.
I’ve tried many times using Unpivoting+Dictionary+Joiner model—then Pivoting to work (first graphic below). But I receive an empty set at the Joiner outcome. I believe it is because I am unable to place S:Value in the lower left box in the Joiner Column Section (second graphic below). The example I was mimicking is the third graphic below.
- How can I fix the above described failing?
- Do I also need to convert Strings to Terms for this endeavor?
- Some columns have a single series of these multi-word text descriptions—but other columns contain many of these multi-word text descriptions separated by commas (I download data from the source as CSV, but am converting it to Excel and using the Excel Reader node).
- After I replace the original text descriptions to the new text descriptions, I will need to complete an additional replacement of the new text descriptions to numeric codes. What additional nodes will I need to add to the model to complete this text to number task?