Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Compose for DW add lookup in Data Mart ETL expression

Hrishikesh
Contributor III
Contributor III

Compose for DW add lookup in Data Mart ETL expression

In the Data Warehouse mappings, there is a lookup functionality built-in to perform any code lookups from the landing tables in Compose.

I was looking for similar functionality in the Data Mart ETL too.

We have built dimensions where some of the column are codes only known to the source system (there are thousands of such columns in our model), in the DataMart layer we want to provide meaningful descriptions for those codes by doing a lookup from the code description dimension (which has very static data that doesn't change very often).

One of the ways to implement this is using custom ETL code in Compose, but since we have so many code columns we are looking for a standard lookup functionality in the Data Mart expressions to avoid maintaining a lot of custom code.

Also we want to avoid doing this type of data denormalization in the warehouse also dont want to create relationships for thousands of code columns, this requirement fits well in the Data Mart/BI layer to be built for reporting.

Tags (1)
3 Comments
Tzachi_Nissim
Employee
Employee

Hi Hrishikesh,

Thank you for your input. This item is on the roadmap. 

 

Regards,

Tzachi

Status changed to: Open - On Roadmap
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived