Format alteryx generated Excel files in a folder in table format as the new output

Question

Hi everyone

I have an analytical workflow that generates output as an Excel file but that means the data is unformatted.

However for consumption purpose i need the data to be formatted.

So there are almost 60 plus files generated in the folder that i need to format in a table format.

One would suggest to render the output as table...i did that as well but the main problem is that i have certain lines output referenced on a particular tab with a particular static cell reference in Excel which i am unable to render because layout tool in reporting doesn't support cell reference.

So it all leaves with me an option to format all files in the folder.

Please note i need everything including file names and tab names to be same as my Excel file with the only difference of it being formatted completely

Sonali_user · Answer

Hi @flying008

Could you help with an example or workflow....i am still very new to alteryx

Also there main problem lies in formatting the sample also which i am unable to do so

Let me explain you in detail my issue

I have 5 different consolidated files as input with multiple tabs which i split using certain logic based on a particular field so in this case each file produces approx 10 files with multiple tabs  as output that is 50  files in total that get saved in that 1 folder

Problem is how do I create sample format for these 5 types of file that i can leverage for others since it has cell referencing used and there are 3 tables to be produced on 1 tab which i am unable to render using table tool

The first sheet has 3 tables with defined cell range

For instance A1 to G5

Next range a7 to c13

Next range a16 to d20

The other sheets are normal like a table.

So i understands when i want multiple tabs...i can simply use layout tool after join and insert sheet name as formula to get multiple tabs but tabs with multiple tables based on cell range become a problem

I cannot upload my file since it's strictly confidential for office purpose but i am trying my level best to explain

Also i tried using render tool wherein in the path field i specified the cell range but that also throws an error and was not working (change entire file path)

Appreciate your help

flying008 · Answer

Hi, @Sonali_user

as your said,

1- create a sample.xlsx with all format.

2- In alteryx event or workflow end, use script to copy and rename sample.xlsx to all your output folders.

3- Set range of output in alteryx output. select option 'take file/table name from field'.