How to identify a numeric value, it contains only numbers in an column ?

Hi Gundappa,

TO_INT(...) should return NULL for all non-converted values.

you could simply use TO_INT(Name) and then filter the component on

FILTER ISNULL(TO_INT(Name)=0)

Hope that helps :-)

BR,

Lars

Hi Lars,

Thank you for the help. I'm able to find the unique numbers within the column but unable to put the filter that give the list of value which has numbers.

I'm trying with below syntax. Please help me on this.

CASE WHEN ( ISNULL ( TO_INT ("TableA_xlsx_TableA"."NAME") = 0 ) THEN 'CLEANSE' ELSE 'PERFECT' END )

Hi Gundappa,

two things:

1. I think the closing bracket in your case when statement is at the wrong place. It should be ISNULL ( TO_INT ("TableA_xlsx_TableA"."NAME")) = 0
2. I would suggest to use a component filter that says FILTER ISNULL ( TO_INT ("TableA_xlsx_TableA"."NAME")) = 0 ;

Hope it helps,

Lars

It works now. Thank you tons for your help.