Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
programXX
Contributor
Contributor

Multiple AND condition in Tmap expression

Hi All,

I am new to Talend and I am building this expression in tmap. can you help me convert the below logic into talend expression?

 

If part.flatRateExceptCode = 0 

and Header.partsFlatRateInd = 'F' 

and Header.partsDollarPercentChrg <>0 

and Part.flatPartAmount <> 0

and not null then

   work_order.part_amount = Part.flatPartAmount

Else 

  work_order.part_amount is NULL

 

thank you!

Labels (2)
2 Replies
manodwhb
Champion II
Champion II

@AAA OOO​ , you need to use the below sample way.

 

row1.flatRateExceptCode ==0 && row1.partsFlatRateInd .equals("F") ? row1.flatPartAmount : null

 

Thanks,

Manohar

programXX
Contributor
Contributor
Author

Thank you! @Manohar B​ will try this..😀