Workflow for MIS tab in excel

Question

So i need help in creating the 'Productive dashboard' tab output in alteryx. I was somehow able to use join tool and create till the first column of output but not able to proceed further for other columns as it has formula which i am not able to recreate in Alteryx. Can someone help me with the workflow showing all the data as reflected in the output iincluding the manual input fields and the table below it as well please. Thanks!

Productivity MIS.xlsx

vshetty7 · Answer

Yes i tried this approach for table. But if you see my attached image i have 8 outputs which i need in separate sheets within one excel file with the naming i added below the output tool. Is it possible to use table tool and render for so many outputs? Its not possible for me to send the workflow as its in a secured system. Also Thank you for helping me.

IMG_5508.jpeg

Yoshiro_Fujimori · Answer

Hi @vshetty7 ,

1. Reporting

Added sample Reporting tools.

2. Order of output tabs

If you mean Excel sheets by "tabs", it seems Alteryx outputs the tabs in alphabetic order of the sheet names.(See attachment)

Input data

Output Excel sheets

So if you can add the sequence number to the head of sheet name, you can order output the sheets in the order you want.

Good luck.

MIS.yxmd

SheetOrder.yxmd

vshetty7 · Answer

Yoshiro_Fujimori 
This helped  me to build  my workflow. But facing two issue.

1.) So i want to format the outputs in tabular form, I added the table tool, i think i also need to add render tool after but getting confused on its configuration. Can you add that and i will see the configuration to use.

2.) Also in my workflow i have 8 output tabs but its not coming in sequence which i want i also added the block until done tool to each but no success, is there an easy way out for that?