Hi @Sampath S ,
Thankyou for the follow up query. I understand you want to convert all the strings throughout the dataset into NULL. Please let me know if that is not the case.
You can make use of column pattern in derived column transformation .
- In the column matching condition , provide
type=='string'
- In column name expression , provide
$$
- In value expression , provide
toInteger($$)
Kindly refer to the below gif for more details:
Hope it helps. If the suggested response helped you, please click "Accept Answer" and kindly upvote the same.