You are not logged in.
Set Hospital as String and ID as Int.
The expression should be
Thanks very much Pedro. I'm following you and I think I've got the structure in place now. However, I'm trying to figure out where the filter expression should go.
You can create a job like this.
Filter the rows which row1.Hospital.equals(row2.Hospital) and row1.ID=row2.id.
Thanks very much for your help.
The input CSV file has:
The mysql database has:
Hospital|ID|First Name|Last Name|Deceased
I want to read the CSV file and update the mysql table when both the hospital and ID fields match.
Thanks again. You guys are awesome.
Could you show me some example data? Input data? Output data?
Then i can reproduce this job for you to explain how to do this.
I feel like I've been running around in circles as I'm learning TOS and I was hoping someone could help break me out of the circles.
I'm using TOS to import several thousand CSV files with individual contact information into a mysql table. I've been able to do this part and it is working very reliably and it was remarkably easy.
Next, I've got several hundred files with flags to indicate individuals who have passed away. The deceased information is related to the other imported files on a compound key of two fields. I know I can import the deceased information into a table and then run SQL to update one table from the other. However, I'm hoping to avoid switching from ETL to ELT. However, I can't quite figure out how to do update an existing table from a CSV.
Can someone point me in the right direction?