(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
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,
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
+2I 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
+2We 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
