topic IN operator (multifull conditions) in Talend Studio

IN operator (multifull conditions)

Anonymous — Sat, 16 Nov 2024 13:49:18 GMT

HI
which component supports IN OPERATOR in TOS?

Regards

Re: IN operator (multifull conditions)

Anonymous — Mon, 17 Aug 2009 04:55:00 GMT

Hello Shiva
Do you mean the In operator in sql? If so, both of tMysqlInput and tMysqlRow allow you to write it.
Best regards

shong

Re: IN operator (multifull conditions)

Anonymous — Mon, 17 Aug 2009 06:21:27 GMT

Hi Shong,

i need to put multifull(more than 2) conditions in tfilterrow,
q:How can i put more than 2 conditons in tfilterrow?
q:tfilterrow supports sql IN operator?if supports,how?
Regards

Re: IN operator (multifull conditions)

Anonymous — Mon, 17 Aug 2009 09:20:37 GMT

Hello

q:How can i put more than 2 conditons in tfilterrow?

You can use the advanced model, eg:
input_row.id>3&&input_row.name.equals("shong") //&& for and
or
input_row.id>3||input_row.name.equals("shong") // || for or

q:tfilterrow supports sql IN operator?if supports,how?

No, it is impossible.
Best regards

shong

Re: IN operator (multifull conditions)

Anonymous — Mon, 17 Aug 2009 15:13:03 GMT

hi thank u for ur information!
q:can u possible to provide inputcontrols in mapping,like parameters in reports?

q:Which components supports for creating a variables in TOS?(other than tmap)

q:how to create variables in tmap?

Regards

Re: IN operator (multifull conditions)

Anonymous — Tue, 18 Aug 2009 03:16:54 GMT

hi
how to change condtions dynamically?
regards

Re: IN operator (multifull conditions)

Anonymous — Tue, 18 Aug 2009 03:45:40 GMT

Hello

q:can u possible to provide inputcontrols in mapping,like parameters in reports?

Sorry, it's not clear for me.

q:Which components supports for creating a variables in TOS?(other than tmap)
q:how to create variables in tmap?

tJava, tJavaRow, eg: globalMap.put("key", value); globalMap.put("key",input_row.name);
tSetGlobalVar: you can define a global var.

how to change condtions dynamically?

Just an simple scenario,
tFileInputDelimited(query the condition: id)--row1--tFlowToIterate--tMysqlInput--tFilterRow(set the condition dynamically, input_row.id>(Integer)globalMap.get("row1.id"))
Best regards

shong