Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Parsing an Excel file with merged cells, missing expected values

ddiesel
12 - Quasar

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:

Capture.PNG

 

The red text is missing when I read the file into Alteryx.

 

Capture2.PNG

 

Output:

 

Capture3.PNG

Qiu
16 - Nebula

@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.

Parse Trouble.PNG

ddiesel
12 - Quasar

Thank you @Qiu! This solution worked. 

Labels