Data overwrite based on count of records

Question

Hello,

I am working on a alteryx workflow that reads a file with two sheets-1)attributes 2)Loans

Loans Sheet has two columns-Loan numbers and category.

My workflow joins the attribute sheet with a sheet from different file and pulls the corresponding data for attributes and writes to a already existing  sheet named attributes and the other part of workflow reads the loan category, divides the loans based on it and writes to two different files with a condition that each sheet will have only 200 loans-done using groupID . (overwrite after each successive run).

Note-This is the same o/p file as the one in which attributes are written after join operation

Since the number of loans could be different in each run hence creating a different number of sheets- my final o/p files contain data overwritten to existing sheets (based on count of loans), but it also ends up containing the old sheets that didn't get written over due to change in number of loans.

How do i solve this?

Thanks in advance!

Shreyash41 · Answer

@grazitti_sapna - I tried what you suggested, a couple variations actually, but that doesn't seem to have the expected effect.

For privacy reasons unfortunately i can't show you the expected outcome as such, but think of it like this-

Every time you are removing the previous file and creating new one, you are not only writing loans, but writing attributes to same file in parallel. Eventually the data written last will survive.

grazitti_sapna · Answer

@Shreyash41  what I was trying to say is you can simply overwrite your existing excel file rather than overwriting the sheets. In this scenario it will automatically remove all the sheets in your excel file and will write with the new one as I am not sure if there is any other way to delete the tabs/sheets from excel. Is it possible for your to share the sample workflow or screenshots for the desired output?

Shreyash41 · Answer

Yes, new loans are simply additional records added to loans sheet in input file. The loans count impact the sheets overwritten in output file. I am trying not to create multiple versions of same file which is why it is a little tricky.