Dynamic Header Data

Question

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?

JanProduct SalesTomA555MikeB334MaryC245

ShankerV · Answer

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

Dynamic Header Data.yxmd

binu_acs · Answer

@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?

zqlcancer · Answer

@binu_acs ，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?