[resolved] many conditions in expression filter of TMap

One Star

[resolved] many conditions in expression filter of TMap

How can I write many conditions in the expression filter of TMap (to have the same result than a SQL request). Is it in Talend a symbol to write an "and" function like this? :
SELECT
REF.CMAITRE,
ARTICLE.CART,
REF.LREF,
LIGNE.LLIGNE,
ARTICLE.STATCOM,
ARTICLE.STATSUP
FROM
ARTICLE,
REF,
LIGNE,
MARQUE
WHERE
( REF.CMAITRE=ARTICLE.CMAITRE )
AND ( ARTICLE.CLIGNE=LIGNE.CLIGNE )
AND ( MARQUE.CMARQUE=REF.CMARQUE )
AND (
MARQUE.LMARQUE = 'JEAN DUPOND XX'
AND ARTICLE.STATCOM = 'RECYC'
)

Accepted Solutions
Community Manager

Re: [resolved] many conditions in expression filter of TMap

Hello
Is it in Talend a symbol to write an "and" function like this?

Try '&&' for 'and', '||' for 'or', for example:
row1.id>2&&row1.name.equals("John")

Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

Re: [resolved] many conditions in expression filter of TMap

Hello
Is it in Talend a symbol to write an "and" function like this?

Try '&&' for 'and', '||' for 'or', for example:
row1.id>2&&row1.name.equals("John")

Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: [resolved] many conditions in expression filter of TMap

How can I put a sql query in entry which displays fields from many tables and not just from one table?
Employee

Re: [resolved] many conditions in expression filter of TMap

hello,
you can create your own SQL query with the tDBInput :
in Basic settings, use the Query panel to write your custom SQL query. you need to have a Talend built-in schema like your SQL select
One Star

Re: [resolved] many conditions in expression filter of TMap

Hello
Is it in Talend a symbol to write an "and" function like this?

Try '&&' for 'and', '||' for 'or', for example:
row1.id>2&&row1.name.equals("John")

Best regards
shong

Thanks you saved me