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: 
Anonymous
Not applicable

Filter data on first character in Talend

Hi,
I have an input flat file data coming as below and I need to filter data based on first character such as "R" and "S" in talend.
Can anyone please suggest me.
Sample data:
R01
R02
R03
S01
S02
S03
S04
S05
Thanks,
Yugandhar
Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hi,
Do you need to filter the row with non-integer value for your column or just filter the row which starts with "S" or "R"?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
I want to filter the row which starts with "S" or "R.

Thanks,
Yugandhar
Anonymous
Not applicable
Author

Hi,
You can achieve your goal in tMap component by using this filter:
row1.newColumn1.startsWith("S")||row1.newColumn1.startsWith("R")
Let us know if it is OK with you.
Best regards
Sabrina
0683p000009MCOS.png
Anonymous
Not applicable
Author

Thank you Sabrina!
Anonymous
Not applicable
Author

Hi,
Thanks for your feedback. Feel free to mark this topic as resolved.
Best regards
Sabrina