- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Source Data structure from Sharepoint Folder has changed
Hello Community -
I have data that I am sourcing from a Sharepoint folder and over time the structure of the files has slightly changed. We added a new column in the extracts to start 2022 and another in 2023. With those additions, when my tables are combined, the columns are not lining up properly with the columns from past files.
I am wondering if there is a function, or way to fix this without going into each file from the past and adding the new column(s). Or manually moving the new columns to the end of the file each month.
Any tips on this would be appreciated.
Thanks
Ryan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi Ryan,
If you're using the folder connector, then the simplest (not necessarily the cleanest) way would probably be to update the sample file query in the helper queries to point at a file with the latest (most columns) structure.
Any transformation you need to do on the new column(s) can then be done post-append, so you don't get errors during the Transform & Combine process.
Pete
Now accepting Kudos! If my post helped you, why not give it a thumbs-up?
Proud to be a Datanaut!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-02-2021 09:05 PM | |||
09-25-2023 03:24 AM | |||
08-05-2024 12:53 PM | |||
Anonymous
| 10-14-2021 06:43 AM | ||
07-18-2024 04:04 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
8 |