Alteryx for Excel Users - Part IV: Transforming Data

[@AFGiant]

I'm watching this whole series and it's great. Onto the final one!

[@tracyann2609]

Thank you, Nathan. This was very helpful!

[@NPT]

You're welcome Tracy. Glad to hear it. 👍

[@teeg3030]

Hi Nathan, could you please do a demo using the interactive chart tool, a stacked bar showing the numbers on the bar and finally export the chart to one excel sheet and the report to another sheet on same workbook as the chart? I'm stuck on showing the numbers on the bars and exporting without overwriting the sheets. Thanks a lot!!

[@nelson_k_d]

Thanks Nathan for your videos!!.. I'm using Alteryx to work with data in excel. The date value when null returns as "00-01-1900 @" when output is created in excel. How can we change all dates from "00-01-1900 @" to blanks? Request your guidance!!..

[@Laxmanmane007]

I am loving it.

[@NPT]

Awesome!

[@sameerjain5000]

How can I write the crosstab output to a new sheet in the Excel file used as the input?

[@NPT]

Hi Sameer, check out my latest video on dynamically outputting sheet names: kzbin.info/www/bejne/rmbSYqWIa5iqf9k You should be able to append a new sheet to the existing input file.

[@NPT]

Link to the data file, President's Inn Guest Database.xlsx: github.com/NeoN8/Alteryx-Data-And-Files

[@radiosonicfan1726]

Love Alteryx. Hey do you any advice on how to deal with excel file with Pivot table, but no data sheet. I can double click grand total to make a data sheet, but defeats automation. Created a excel macro to create data sheet in excel. Can alteryx run macro to create data sheet, then proceed with workflow.

[@tonydoberman21]

nice video

[@NPT]

Thanks