Input Data wildcard not working when there are blank columns

Hi,

I am trying to use an input data wildcard to read in 12 files of the exact same format / column names. For approx. half of the files, Alteryx is reading 2 blank columns to the far right of the dataset as F30/31. I believe this is why the wildcard is not working.

I am confused why this is breaking the input given that if you use a union tool the files would still stack, you would just have a files showing nulls for those two blank columns.

Given there is no way to configure the columns to be brought in on a wildcard, is there a way around this?

Thanks in advance!

Input

Tips and Tricks

Bug

Accepted answers

afv2688

Hello @nrubner1,

As you said yes, this is a limitation of the wildcards. Inputs need to have the same columns (column names and amount) and same data types to be able to merge all the files.

Regards

All comments

afv2688

Hello @nrubner1,

try using this macro. It comes with a workflow where you can try it out.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Read_excel.zip

nrubner1

Hi afv2688

Thanks for the macro! This is a great tool, but unfortunately doesn't fully solve my question:

I need to read in from row 15 of each file only. I guess I could go in and amend the macro, but I was hoping to find a solution that would be accessible to beginner users also.

I was also keen to understand if this issue was resolvable di

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703