I am tasked with parsing some excel files with a messy structure. Some of the values that appear in merged cells are missing when I read in the file to Alteryx. How do I get at the data that I'm missing?
Sample Input:
The red text is missing when I read the file into Alteryx.
Output:
Solved! Go to Solution.
@ddiesel
I am not sure if your workflow allows to change the .xls to xlsx, buf after I saved it as .xlsx, Row#37 is read in somehow.
Thank you @Qiu! This solution worked.