You are not logged in.
Announcement
Unanswered posts
|
Thanks, it works.
During this time i also found an other solution :
EXCEL FILE
|
Row1
|
TFlowToIterate
|
Iterate
|
TMySQLRow(DELETE FROM <table1> WHERE id=row1.id)
|
Iterate
|
TMySQLRow(DELETE FROM <table2> WHERE id=row1.id)
|
Iterate
|
TMySQLRow(DELETE FROM <table3> WHERE id=row1.id)
I prefer your solution because it use less task.
Hello
Please try:
EXCEL FILE ---- row1--- TlogRow
|
|
Iterate
|
|
tForEach_1(add three values: table1,table2,table3)--iterate-->TMySQLRow ("DELETE FROM "+(String)globalMap.get("tForeach_1_CURRENT_VALUE")+ "WHERE id="+row1.id)
Best regards
shong
Hello,
I'm a beginer with TOS.
I'm parsing a Excel File containing id corresponding to records of a mysql database. I need to do statement on 3 tables using the id extract from Excel File.
I do the following
EXCEL FILE ---- row1--- TlogRow
|
|
Iterate
|
|
TMySQLRow (DELETE FROM <table1> WHERE id=row1.id)
This works fine and delete records on table1.
But I don't know how to do the delete statement on other tables. I looking for a structure like this :
EXCEL FILE ---- row1--- TlogRow
|
|
TMySQLRow (DELETE FROM <table1> WHERE id=row1.id) ----------Iterate------------TMySQLRow (DELETE FROM <table2> WHERE id=row1.id)
|
|
TMySQLRow (DELETE FROM <table1> WHERE id=row1.id)
I don't know if it is possible to do this with Talend.
Please help me :)