Skip to main content
Solved

Query to get column name from different table stores as column value


We have data model with

type abc{id: String

kind: String

name: String

description: String

key: String}

In other table , we have these columns stored as column values

kind attributes
1.0.0 name
1.0.0 description
1.0.0 key
1.0.0

name

 

need query to join on column value(stored as rows) from one table with solution model table data can group on by id or kind? As there can be n number of attributes, if we can do it dynamically to match column  value with column name.

Any help would be appreciated

Best answer by Dilini Fernando

Hi @Rimmi Anand,

I’m closing this topic now, please feel free to create a new post if you still experience problems.

Best regards,
Dilini 

View original
Did this topic help you find an answer to your question?

3 replies

joar.saether
Practitioner
  • Director Site Reliability Cognite
  • 6 replies
  • October 28, 2023

Hi Rimmi,

 

Can you add a little bit more context to your question?   

  • Is the table you mention here stored in RAW? 
  • Is the query you want to create going to run in transformations?
  • Is the purpose to create new instances from the table?

Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • 671 replies
  • November 9, 2023

Hi @Rimmi Anand ,

If this request is still valid, please provide the required information. We are happy to help you.

Best regards,
Dilini


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • 671 replies
  • Answer
  • November 22, 2023

Hi @Rimmi Anand,

I’m closing this topic now, please feel free to create a new post if you still experience problems.

Best regards,
Dilini 


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings