Creating file with 3 tabs

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.

Data Investigation

Accepted answers

dougperez

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

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

dougperez

You need this?

3tabs.yxmd

All comments

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.

3tabs.yxmd

dougperez

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703