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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
hechmi
Contributor III
Contributor III

reject line having Alphanumeric and special caracters

Hi All;

 i  have tabel input data have   line of name and state i want to reject line having  Alphanumeric  and  special caracters with  tmap or other composant :

input data-------table out put  reject (name and state with  Alphanumeric  and  special caracters and   int)

                        table out put reliable (name and state without   Alphanumeric  and  special caracters)

 

Thank in advance

  

Labels (2)
12 Replies
hechmi
Contributor III
Contributor III
Author

i thks 

i do a test in table  i see that state have a value alphanumeric us you see in screen alph2.png

i test var==true and var ==false but no solutionus y see 

 best regard s

hechmi
Contributor III
Contributor III
Author

also i set Catch output reject in tmap" false but nothing change
0683p000009MPcz.png
Anonymous
Not applicable

Just test 2 records; 1 that should work and 1 that should not. Create two outputs in your tMap; 1 for positive and one for negative. Connect the outputs to tLogRow components. This way it will make it easier for everyone (and you) to see what is happening.

 

My question was about why you the the tMap output set to "Catch output reject" = True