Update and Insert the records in the existing table

[Anonymous]

Hi guys,

I have design a job as in attached image.

Firstly, I clear the table and insert data.

Secondly, I update or insert data to the table but the process do not follow the order.

The first inputDB in starting state and can not finish.

Pls advice on this case, thank you so much.

[bhagyarekha]

Hi ,

As per my knowledge you should do insertion job, then you should go for on subjob trigger for next updating records

but when i see your screen shot,my question is what is the need for updating the records when the same input you are inserting in the table.

can you explain me what is your requirement 

Regards

rekha

[Anonymous]

Thank you so much for quick reply.

I have two tMap output like in screenshot.

One i do check string length for Street, one I do for LastName.

I want to update row if record with same CUSTNO have both Street and LastName needed to be trimmed.

[bhagyarekha · Accepted solution]

hi 

just give me sample input and out put you are expecting.both condition are mandatory to check?

see on first condition street >32 means lastname should be any length right, those you want to insert?or if you want to check lastname length go condition in column.

Use insert or update,first it inserts record in table,if the record is their it updates next