Hi all,
I am trying to use the 'Find and Replace' function to append a field to my existing records. Please see attached excel as reference.
I want to append the 'terms' column to my original file using the 'category' column as reference. Than, I want to generate additional rows in my original file, depending on how many terms there are. So, for 'metastatic' two additional rows should be generated. I have created a map key file like the one attached. However, the field are not appending to my record - Alteryx has created another column on my original file titled 'Category2' with [Null] for all the records. Also, when i use the 'Generate Rows' functions with conditional expression as RowCount <= [Number of Terms], I'm getting a Parse Error at char(14): Unknown variable 'Number of Terms'.
I'm not too sure what i'm doing wrong here. Many thanks in advance!
