
(RAW Table : As above which has total 179 columns #41 contains numeric data 138 contains text data)
I have ingested data in raw table….now I want to get only data of 41 columns which has number data type ?
how this can be done in the transformation?
similar query I want to run for remained 138 columns which has “Text” data type?