ExcelHoover Error - Row Follows Row.Unmerge cells for input file?

Question

I am using excelhoover macro that gives me consolidated data from a hundreds of excel files stored in a directory. I haven't had an issue with this so far till today when one of the input files in the directory has "Merge&Center" cells. Sample below. The Merged cell1 and merged cell2 in the below image of the file is causing an error. Is there a way for me to use Alteryx to unmerge these cells across all the files instead of manually unmerging them one at a time?

jrlindem · Answer

@sowjanyayinti - Did you get this resolved?  Otherwise, please attach some input file examples or provide more context.  Thanks, -Jay

ChrisTX · Answer

Can you post a few sample input files, maybe with dummy data?  and your workflow.

Also try the batch macro attached at the bottom of this blog post. ("what happens if your field schema is different from one file to another?")

The Ultimate Input Data Flowchart
Community > Designer > Designer Knowledge > The Ultimate Input Data Flowchart
https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

Chris

jrlindem · Answer

Might be worth pursing upstream to whatever process is generating all those excel files and working with them to adhere to the schema / format that your part depends on.  Situations like this are tough, because we aspire for true automation, but sometimes a little manual intervention is quicker than overhauling an otherwise stable process.

Hope you're able to figure it out.  Cheers, -Jay