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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dramya
Contributor
Contributor

How to filter the record using tmap with description column which has unique word 'PAY'

I want to get all records in seperate column which has the word 'PAY'. Hw to acheive it using tmap?

Labels (3)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@RAMYA DHANASEKARAN​ , you wan to get the records which had PAY records to out put ? then in tMap output section enable filter option use the code below way.

 

("PAY").equals(row1.col)

 

Thanks,

Manohar

View solution in original post

2 Replies
manodwhb
Champion II
Champion II

@RAMYA DHANASEKARAN​ , you wan to get the records which had PAY records to out put ? then in tMap output section enable filter option use the code below way.

 

("PAY").equals(row1.col)

 

Thanks,

Manohar

dramya
Contributor
Contributor
Author

Thanks @Manohar B​ .. I tried by adding row1.fieldname.contains condition​ to my job to bring the records seperately. Solution provided by you is also working.Thanks!!