We have data model withtype abc{id: Stringkind: Stringname: Stringdescription: Stringkey: String}In other table , we have these columns stored as column valueskind 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

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?

Answer

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

Forum|Forum|2 years ago
October 18, 2023
3 replies
78 views

R

Rimmi Anand
Seasoned

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