IN operator (multifull conditions)

One Star

IN operator (multifull conditions)

HI
which component supports IN OPERATOR in TOS?

Regards
Community Manager

Re: IN operator (multifull conditions)

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: IN operator (multifull conditions)

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
Community Manager

Re: IN operator (multifull conditions)

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: IN operator (multifull conditions)

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
One Star

Re: IN operator (multifull conditions)

hi
how to change condtions dynamically?
regards
Community Manager

Re: IN operator (multifull conditions)

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
----------------------------------------------------------
Talend | Data Agility for Modern Business