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?

Solved

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

6 months ago
18 October 2023
3 replies
62 views

R

Rimmi Anand
Seasoned
3 replies

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

icon

Best answer by Dilini Fernando 22 November 2023, 07:58

View original