topic Re: Verify if datas exist before implement DB in Talend Studio

Verify if datas exist before implement DB

LDPtechAFB — Sat, 16 Nov 2024 01:44:09 GMT

Hello, Once my file is parsed, i want to implement a DB but before that i have to check if some infos match with infos already present in the database.

I want to

Parse my file -> check if the row already exist -> then implement or not (if i'm not implement this row, i have to get the ID of the row that are actually the same to fill my foreign key values)

I tried with a TDBinput but actually i don't succeed to get values to compare with (for example i want to compare if my values from the row39.areaUnit is the same that another one in my database).

Here is the tDBInput configuration.

and it return NULL from the tlogRow.

I also tried with a tDBrow but i think i don't use it well.

Feel free to ask me more details, it is a little bit hard to explain clearly

Re: Verify if datas exist before implement DB

manodwhb — Wed, 05 Aug 2020 14:20:06 GMT

@not specified not specified ,with out where clause in tDBInput, are you able to get the data was it working?

Re: Verify if datas exist before implement DB

LDPtechAFB — Wed, 05 Aug 2020 14:22:49 GMT

Yes i am able to get all datas,

and i have all rows of the database in my tlogrow

Re: Verify if datas exist before implement DB

LDPtechAFB — Wed, 05 Aug 2020 14:56:03 GMT

((Integer)globalMap.get("tDBInput_1_NB_LINE"))==0

I just found a way to use a global variable but i can't modify my tDBInput to correspond to what i need to compare

Regards

Re: Verify if datas exist before implement DB

LDPtechAFB — Thu, 06 Aug 2020 07:46:05 GMT

For now the best i can do (it works btw) is to put a tSetGlobalVar befor the machine_thash_output then configure my tDBinput like :

"select * from machine WHERE MachineK = " + "\""+ globalMap.get("GUID") + "\""