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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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..😀