Solved

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

  • 24 March 2023
  • 4 replies
  • 89 views

Userlevel 2
Badge

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

icon

Best answer by Dilini Fernando 7 April 2023, 09:55

View original

4 replies

Userlevel 2
Badge

Hi Team,

any solution to achieve this?

 

Regards,

Sonali

Userlevel 1
Badge

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
 

Userlevel 4
Badge +2

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

Userlevel 4
Badge +2

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