Creating file with 3 tabs

[Matiassta]

Hello,

My data:

student_id	status	date
11101	High	24-05-21
22201	Medium	24-05-21
22201	Low	20-05-21
33301	Low	24-05-21

I would like to create an XLSX file daily for each date. That file needs to be like "Student_+[date]". So each date will have its file. For example: 

Student_20-05-21

Student_24-05-21

Inside the file, I would like to have 3 tabs of each status (Low, Medium, High), which hold the same name for each tab (Low, Medium, High).

I was trying to achieve and it ran perfectly for the first tab on the workflow and after stop running at the second one.

Please advice.

[Luke_C]

Hi @Matiassta 

Try the attached. To make this work you need to create a field that has your file name (with the tab name), then choose to change the entire path in the output tool configurations. 

[dougperez · Accepted solution]

I changed to '".\"+"Output.xlsx|||"+[status]' and it worked in my computer....

Try to change the "Overwrite" option in the Output Options

[Matiassta]

@luca_c

I have tried it and it works but just on the first filter (for example Low)

My workflow works it does the same as you show for each status. So I filter the data into low, then write it into the file and after to the Medium and so on.

On the low (which it's the first one) it runs fine, but on the next one it can't run

[Luke_C]

Hi @Matiassta 

Can you share your workflow? Or a simplified version of it? You should not need to filter each category so I'm not sure I follow the issue or desired outcome. The solution I shared will put the records associated with each status on a separate tab of the same workbook. 

[Matiassta]

@dougperez

Thanks man, that is brilliant! 

Just one thing I need to achieve to make it perfect is to remove that file("filename" in your example) from the output.

Do you know how could I achieve that?

[dougperez · Accepted solution]

You need this?