topic reject line having Alphanumeric and special caracters in Talend Studio

reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 13:11:20 GMT

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

Re: reject line having Alphanumeric and special caracters

Anonymous — Wed, 19 Sep 2018 13:21:09 GMT

Hi,

Could you please try below function in tmap? It will give a boolean output based on the string condtion. Use this boolean value in expression filter of the output schema as condition to reject bad records.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 14:45:43 GMT

thks;
but not good solution are you have other help
best regards

Re: reject line having Alphanumeric and special caracters

Anonymous — Wed, 19 Sep 2018 15:01:52 GMT

Hi,

Could you please advise the issue you are facing when you tried the above function? If you could provide the screenshots of the error, it will be more helpful to understand the problem in detail.

Warm Regards,

Nikhil Thampi

Re: reject line having Alphanumeric and special caracters

TRF — Wed, 19 Sep 2018 15:07:11 GMT

@hechmi, if you know this is not a good solution, you probably know a better one.

In such a case, why are you asking for a solution?

You should share your own.

Re: reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 15:25:55 GMT

@TRF
sorry ;
but i want to say , i try with yor help but i don t have a solution
i m so sorry
best regard

Re: reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 15:45:14 GMT

thks

i have only one reject u see in in screen but when i use isalpha i don t seethe good result

you can see the attached screen

best regard

isalph1.PNG
isalpha.PNG
isalpha2.PNG

Re: reject line having Alphanumeric and special caracters

TRF — Wed, 19 Sep 2018 15:54:36 GMT

Don't know which tool you're using to check the data on isalpha2.PNG picture.

Anyway, what about null value?

StringHandling.IS_ALPHA will consider null values as non alpha values, so concerned records will be rejected.

Re: reject line having Alphanumeric and special caracters

Anonymous — Wed, 19 Sep 2018 16:03:48 GMT

I agree with TRF, how do you know that the record you showed did NOT get rejected? Your screenshots show thousands of records being accepted and a significant number not being accepted. This is a bit confusing at the moment. Can you test with 2 records; 1 good one and 1 bad one?

Re: reject line having Alphanumeric and special caracters

Anonymous — Wed, 19 Sep 2018 16:05:25 GMT

I've just noticed, why do you have "Catch output reject" set to True in your tMap? This should be false.

Re: reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 16:08:30 GMT

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

Re: reject line having Alphanumeric and special caracters

hechmi — Wed, 19 Sep 2018 16:12:09 GMT

also i set Catch output reject in tmap" false but nothing change

Re: reject line having Alphanumeric and special caracters

Anonymous — Wed, 19 Sep 2018 16:12:32 GMT

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