Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

greg
2009-03-04 10:59:32

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.

shong
2009-03-04 10:33:58

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

greg
2009-03-04 10:16:15

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 :)

Board footer

Powered by FluxBB