Hi I have a multiple files with .csv format with huge size that are being zipped. I want to know the easiest way to input aside from wildcard method. I want to know how to utilize the batch macro in inputting the files as some of them do not have common file name. For today, I only uploaded the sample data only. I want to bring the files into the canvas using the batch macro. Please see attached file. Can you help me with this one pls? Note: This is a sample data only.
Would like to clarify a couple of points:
- Do you want to read all the files without unzipping the zipped file? Or it's ok to unzip everything to a folder first before the reading them.
- By "input" do you mean to extract all the data into one single output file? Or something else?
- Do all the files have the same schema?
This is a fairly popular question and the good news is the community members have got some very good answers, check them out via the below links:
Regards,
Dawn.