Dynamic Header Data

[zqlcancer]

I need combine some data to a table but my problem is one the column header changes every time and should stay as the 1st column in the table. As the column header is fixed in 'Table' tool, I need make manual adjustment to fix it. Is it possible to do this automatically in Alteryx?

e.g.Header of column A in my sample is Jan this time, but next time it could be changed to Feb or Mar. How can I make sure 'Table' tool get data from column A everytime? 

Jan	Product	Sales
Tom	A	555
Mike	B	334
Mary	C	245

[binuacs]

@zqlcancer One way of doing this with the dynamic select tool, 

[zqlcancer]

@binuacs ，thanks for sharing, this helps me to learn a new tool. However when I tried to input my expression, it seems I can not use an existing column(in my case, First_First_Last Day of Last Period is an existing column name). Is this the case or am I miss anything?

[binuacs]

@zqlcancer the DateTimeFormat() formula works on the dates, you mentioned one of your column heading will be Jan, Feb etc , in that case you need to use the above formula to pick the correct column based on the month name. Can you provide a sample file with your existing name and expected output?

[ShankerV]

Hi @zqlcancer 

I can approach this question in a different view.

As per my understanding, initially you will have the input file with below details.

So the Basic Table output will be like this, 

Next time, the column A will be changed to Feb or Mar.

For the next run also, it will pick the same column changed.

As you are using Dynamic or Unknown Fields option selected.

I haven't changed any modification to the workflow, just ran with the amended input file.

Many thanks

Shanker V