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?

R

Rimmi Anand

Practitioner ⭐️

Solved

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

3 replies
112 views

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