We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Loop through columns in Find Replace Tool

TinaZhao
6 - Meteoroid

I have a dataset that contains several columns of keywords that I wish to do keyword search on. Is there a way to loop through those keyword columns in "Find Value" of Find Replace tool and append each column? Attached the sample dataset below. I think about doing an iterative macro but idk how to update the find value in the tool.

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@TinaZhao 
If I understand your intetion correctly, we will need a mapping file for find and Relace first then we can use the combination of "Transpose" and "Cross Tab" to dynamiclly handle multiple columns.

1223-TinaZhao.png

Labels
Top Solution Authors