Thank you! This was great I was able to merge around 3,000 csv files and originally thought I was going to have to load each one manually into a data model
Thanks for this, I had no idea I could use the DOS copy command to do this so simply. I've been struggling with this do the copy and past thing one at a time. Do you know if there is a way to set a date in multiple csv files?
Nice video, i have been searching all week on how to do this. Please does this work with multiple csv files with different number of columns?. I want to merge 117,350 csv files of different column into one master csv file
Question: Each of the 'input' .csv files has a 'header row' (row 1)... Would not these header rows cause issues in scattered throughout the 'output' .csv file?
Hey Rasstag! I assume you've already tried it. But just to answer your question - no, this wouldn't automatically arrange your entries according to headers. But in case like if you only have 3 columns/headers (e.g. Name, Address, Phone) I recommend you put them in the order you prefer (do this on each CSV) before you proceed with this trick.
Its not working for me. I dont have command prompt. There is Windows PowerShell. Also my files are ziped and I also tried with a new folder. What am I doing wrong???
@@theexecutiveva4383 thanks for your reply. There is some issue with the file name (volume label syntax is incorrect) Could you highlight some steps in that part to be aware?...thanks a lot 🙏