community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Sheet has a different schema than the 1st file in the set and will be skipped

Highlighted

Hi Guys @AlexKo @jdunkerley79

 

I have bunch of files and each file has same structure and sheet name. I wanted to pic data from the same sheet of every file.

I am using batch macro to achieve this but still i am getting same warning for few of the file which is "Sheet has a different schema than the 1st file in the set and will be skipped". 

 

Can someone help on this. 

 

Please find attached workflow.

Pulsar

In your batch macro, go to Interface designer (View menu) and select Auto Configure by Name.

 

Rememer to save your changes and refresh your workflow.

 

batch macro interface designer.png

Pulsar

I had another look at your macro.

 

If you know the Sheet Name is always 'SourceFile', just add it to the [Fullpath] field and use [Fullpath] as your only Control parameter. Also, it looks like your data starts at cell B3 and finishes at Column Q, so you can limit the range of what you load to only that by adding that to your filename, like this:

 

[FullPath]+'|||SourceFile$B3:Q'

 

See if the attached works for you.

 

 

 

 

Labels