Need separate column header for data from cross tab and use both the headers

[DD]

Hi All,

I need help with the below workflow, had got desired results from cross tab and join multiple tools but for those output results I need to create standard unique headers to populate on top of the output results as shown in the expected results. Tried with Dynamic rename tools, but dates got replaced to Today, Yesterday and others which is not as expected. 

Expected results

Results am getting from Alteryx 

Used dynamic rename tool and join tool, but this has replaced dates with the new headers, wherein I need both dates and new standard headers as this is further extracted through. hyper output tool to refresh tableau, having dates causes error in tableau as it picks new dates data every day when refreshed in tableau.

Created text input tool added below data -

Used two ways 1) text input tool - dynamic rename tool - select and join = RESULTS SHOWN BELOW

2) Text Input tool - Unique - formula - cross tab- select - Join - dynamic rename tool - browse = same results

[binuacs]

@DD Can you provide the sample input file and expected result? 

[DD]

hi @binuacs

Please find attached sample input file in sheet 1 and expected result in sheet2

[grazitti_sapna · Accepted solution]

Hi @DD , Please use the following workflow to achieve your result. Sharing the snip of the output. You can achieve it by using text tool and table tool.

[DD]

Thanks a lot, Sapna :)

[DD]

Is there a way to have connect output file as .tde or .hyper for this solution, as i have to connect 5 other joins and these reports need to be refreshed through tableau

[binuacs · Accepted solution]

@DD One way of doing this.You can use the output file tool and select the .hyper extension

[DD]

thank you so much, it worked out :)

[DD]

Thank you very much Binuacs, please can you share the workflow as well it would be helpful.

[binuacs]

@DD sorry I thought I attached the workflow