03-09-2017 06:01 AM - edited 03-09-2017 06:04 AM
I've 25 text files which has reading from a machine everyday for 25 days, with no column names and seperated by ";". I'm trying to read all the text files and append them to get the one file with 25 days data. for this, I use Loop Files operator. Inside Loop files operator, I'm using the Read CSV operator and using the import configuration, I've imported one file and unchecked the first row as names option.
This process is working fine when I keep the files in one folder and throwing error when keeping the files in other folder and giving the folder for loop files operator.
I've checked that every file has same number of columns and the same files can be read when keeping in a different folder. Can anyone please help on this ?
03-09-2017 08:31 AM
Can you try using a Read CSV operator but don't do the import config wizard? Leave that all blank, it should just load in the CSV files but with default data types.