Related Posts
Please help me to get 11 likes.
Additional Posts in Data & Analytics Consultants
today I choose violence

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Please help me to get 11 likes.
today I choose violence

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

Chat gpt is a different app
i would upload them as 5 separate tables and then create a new table to union them all.
also, in all seriousness, chatgpt is really good at this sorta thing.
UNION is likely your friend. Alternatively, or as part of a crazy process, so might UPDATE TABLE be...
also be thinking about the reason you would append data sets like that. do they have same columns? or will roll up for something else etc
Ooh! I've actually had data come from different resources like this. If you are centralizing contact data from Marketo (prospecting), Salesforce (sales), website, POS (retail location), and service record (siebel/SAP). Needless to say, this moved from a consolidation problem to an ID management problem. I wouldn't recommend solving anything like I did. This should have been a budget request for an ID resolution package, then stage each set, clean and standardize each, then assign the ID, and then join like a champ.
I would combine the flat files as one file in excel first. This tutorial seems helpful! https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-flat-file-wizard?view=sql-server-ver16
doesn’t work if the files are millions of rows.
Thanks all!
Temp tables