Hi all,
I did some research but didn't found the exact solution to my problem.
I'm trying to output an Excel file in format .xlsx
I need to have a new file everyday with a timestamp in the name of the file.
I want my output to be like an already existing Excel file.
In first tab, I need my data from Alteryx with the same template as Excel (nice colors, formatting, ...).
In the second tab, I need the exact same tab as the one from the Excel template.
Summary : First tab = New data with same formatting as Excel, second tab = nothing change, New Excel file everyday.
Usually I use a formula tool to create the full path name :
Full_Path_Example\'Name_Of_File' + DateTimeToday()
+ '.xlsx|||Name_Of_Sheet'
I hope my explanations are understandable, don't hesitate to ask me some questions.
Thanks a lot if you could help as I'm a bit lost on how to do.
Best regards,
Axis
@Axis
Can you give a sample output with some forget data?