Multiple output needed

Hi Team,

Thanks for your help in advance.

I have to extract data from specific tool by SQL which is of Billions of rows. I have to separate that them by department and there are more than 3000 department. The problem is that I have some department which has more than 9 lac of rows and the files are needed in excel or csv format.

Can I have a workflow to fix this? and how Block until run can be used in this scenario.

Thanks

Output

Accepted answers

binu_acs

@mmustkee use a summarise tool and take the count of the departments, if any dep count exceeds the limit write all of them in a separate file with a message Exceeds limit, and process the rest of the departments

Excel_12082024.yxzp

All comments

binu_acs

@mmustkee are you expecting 3000 excel output files also if the record count is more than some specific count for a particular dept, should that write into the next tab?

mmustkee

Hi @binu_acs

I am expecting 3000 separate excel files and if one department has more than millions of row which is excel max limit. The workflow should run successfully for rest of the department and I should get response that specific department could not run due to max limit.

mmustkee

Hi @binuacs

binu_acs

Excel_12082024.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703