select one column by using keywords in specific column

Question

Hello there,

My source file is from excel, what i want to do is to select one column from excel by keywords provided.

For example, source file has 4 column with column name - A/B/C/D, there is a control parameter will provide keyword, possibly it will be A or B or C or D. when parameter is B, the tool will select B column data.

And final step will select this column by keyword providing by control parameter and copy this line to excel new sheet.

Is there any quick way to solve this problem? Thanks in advance!

philosophy22 · Answer

Hi, @Qiu

I apply your solution, but alteryx pop up error message like this, i use macro to solve this problem. The variable in red color is what i want to choose to select and copy to new sheet.

In this macro, I use your parameter control tool and dynamic select, I set these tools just like you, but cannot run this part in the whole project. I wondering if you can help me? thanks a lot

ArtApa · Answer

@Qiu - Haha 😁

ArtApa · Answer

Hi @philosophy22 - I designed the following app for you:

Select Column AA.yxwz

Select Column AA.yxzp