Columns with data in excel showing as null in Alteryx

[kyorio]

Hi everyone,

I am trying to read excel binary files into Alteryx and there are some fields that have content in excel that are showing as null in Alteryx. I tried changing the field type, but that did not help. Does anyone know what the issue is? Thanks!

[kyorio]

If you're able to find an alternative solution that would be great.

[pedrodrfaria]

@kyorio 

Would a workflow that batch converts the binary files into xlsx files work for you? You would not lose anything, it would run a Command Line in order to just convert them.

This way you can then set up the workflow to take in a xlsx file instead of a binary file.

I have attached an updated version of a workflow I had worked on to in this case take in binary files and convert to xlsx.

Pedro.

[kyorio]

The workflow doesn't seem to be working. The true statement of the filter is blank.

[pedrodrfaria]

@kyorio 

I updated the workflow.

[kyorio]

I'm getting this error now:

[pedrodrfaria]

@kyorio You just need to remove the question mark and add the macro I had sent previously to that position.

[kyorio]

I'm still getting an error:

[kyorio]

@pedrodrfaria I got the workflow to run without errors, but now I don't see the .xlsx files in the same folder where I have the .xlsb files. Could they be saved somewhere else?

[pedrodrfaria]

Hi @kyorio 

Were you able to fix the previous error correctly? You just had to update the file path to your computer.

I just tested it and I was able to create the file in the same folder as the previous one.

Can you confirm if the macro ran properly? The same quantity of iterations are you have files.