Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

LoopFiles+Read CSV Operator not working

krishnakrishna Member Posts: 6 Contributor II
edited November 2018 in Help

Hi Team,

 

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. 

 

Error.jpg

 

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 ?

 

Thanks

Krishna

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,761 Unicorn

    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.

  • AndrewAndrew RapidMiner Certified Expert, RapidMiner Certified Master, Member Posts: 47 Guru

    I notice that the Loop Files operator is a deprecated one. If you change to the latest, does it work?

     

    Andrew

Sign In or Register to comment.