Sharepoint Connector - duplicating data

Question

Hi All,

Has anyone tried importing via the sharepoint connector:

Excel worksheet with a sheet name and range defined in the configuration

Multiple excel spreadsheets in folder with the same structure

Alteryx successfully imports each range from each file.

For the 1st file - appears in the table, duplicated for each file in the folder (meta data incorrectly assigned to the content in the range)

For the 2nd file - appears in table duplicated for each file apart from first

3rd - same but duplicated for 3rd and subsequent files etc...

So if I have 5 files, I get 5 lots of file 1 with the meta data of each file, 4 lots of file 2 with meta data of file 2-5 etc....

Thank you!

avafhlyru · Answer

@McGillNeil wrote:Hi All,

Has anyone tried importing via the sharepoint connector:

Excel worksheet with a sheet name and range defined in the configuration

Multiple excel spreadsheets in folder with the same structure

Alteryx successfully imports each range from each file.

For the 1st file - appears in the table, duplicated for each file in the folder (meta data incorrectly assigned to the content in the range)

For the 2nd file - appears in table duplicated for each file apart from first take your time here in the most beautiful place with https://spinsycasino.co.com/ great bonusses and wins

3rd - same but duplicated for 3rd and subsequent files etc...

So if I have 5 files, I get 5 lots of file 1 with the meta data of each file, 4 lots of file 2 with meta data of file 2-5 etc....

Thank you!

Hey, that sounds pretty frustrating! From what you’re describing, it seems like Alteryx is treating each file as a separate stream but is incorrectly associating metadata across the files. This might be a result of how the metadata is being handled when pulling in multiple files—like it's not resetting properly between iterations. A quick fix could be to check if you’re using a "Dynamic Input" tool with a proper configuration to reset the metadata for each new file. Also, make sure your sheet and range parameters are set correctly across all files so they don’t overlap. Hope that clears things up!