Hi every body. I want to read a excel file line to line.
0
Answers
sgenzerAdministrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts: 2,959 Community Manager
hi @lebela can you a bit more specific? What exactly are you trying to do?
Hi sgenzer, thanks for your answer. I want to insert into tha database table the nformation off the Excel File. In this case, i think i need read the file line to line and make the sql sentence
0
sgenzerAdministrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts: 2,959 Community Manager
hmm ok that's still vague but basically if you want to get information from an Excel file line-by-line, you can use Loop Examples. Maybe something like this?
Use the Read Excel operator, and connect it to the end.
Use the Select Attributes operator to select only the attributes you want from your Excel file.
Use the Rename operator to rename the attributes to the fields in your database.
Use the Generate Attributes operator if you need to generate a new attribute (unlikely).
Use the Write Database operator to write the data directly to the database.
You don't normally have to write line by line, as the Write Database operator does the INSERT process for you. There is another operator named Update Database if you have the ID and want to update the database with the values from your Excel files.
Answers
Scott
Check this:
- Use the Read Excel operator, and connect it to the end.
- Use the Select Attributes operator to select only the attributes you want from your Excel file.
- Use the Rename operator to rename the attributes to the fields in your database.
- Use the Generate Attributes operator if you need to generate a new attribute (unlikely).
- Use the Write Database operator to write the data directly to the database.
You don't normally have to write line by line, as the Write Database operator does the INSERT process for you. There is another operator named Update Database if you have the ID and want to update the database with the values from your Excel files.All the best,
Rod.