Skip to main content

(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?

Hi Team,

any solution to achieve this?

 

Regards,

Sonali


Hi,

You can use the profiler to see the predict type of your columns, but AFAIK, we can only get names but not types of columns for Transformation query from this UDF
https://docs.cognite.com/cdf/integration/guides/transformation/write_sql_queries/#get_names
 


Hi @Sonali Vishal Patil,

I hope Vu Hai’s explanation was clear to you. I'm closing this thread now, but please feel free to respond if you require any further assistance. 

Br,
Dilini


Hi @Sonali Vishal Patil,

We appreciate your contribution to our community hub! We’ve moved your article to our hub's How-To section as it will greatly benefit other members of our community. Thank you for your understanding, and we look forward to seeing more great contributions from you in the future! 

Best regards,
Dilini 

 


Reply