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
Solved! Go to Solution.
@DD Can you provide the sample input file and expected result?
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.
Thanks a lot, Sapna :)
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
thank you so much, it worked out :)
Thank you very much Binuacs, please can you share the workflow as well it would be helpful.
@DD sorry I thought I attached the workflow