multiple column headers dynamic select

[philosophy22]

Hi,

I am facing a tough situation, I need to dynamic select column which is highlight in yellow. There are two column header rows in the excel table, which we should choose first header as Total( Tie with CMOD TB)，not other columns. The second headers are all domestic and foreign. In this situation how can I select the column i wanted? Thanks in advance!

[Qiu]

@philosophy22 
There is a tool namely "Dynamic Select", where you can define a filter to select the columns.

So it will work if your target columns have some common “Key Word”.

[philosophy22]

@Qiu Yes, but how can i manage this, since the second header is same as "foreign""domestic"

[NexBK · Accepted solution]

Hi, @philosophy2

Alteryx can only use a single line of column names.
Therefore, you can modify the name of the column by combining the name of the first column and the name of the second column, and choose what you want with dynamic select.