How to get list of the columns from raw table which is in number & text format? [Community Contributed]

Forum|Forum|3 years ago
March 24, 2023
4 replies
137 views

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

Best answer by Dilini Fernando

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

S

Sonali Vishal PatilAuthor

Seasoned ⭐️⭐️⭐️

Hi Team,

any solution to achieve this?

Regards,

Sonali

V

Vu Hai Nguyen

Practitioner ⭐️⭐️⭐️

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

Dilini FernandoAnswer

Expert ⭐️⭐️⭐️⭐️

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

Dilini Fernando

Expert ⭐️⭐️⭐️⭐️

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

Sign up

Welcome to Cognite Hub