Discussion board where members can get started with QlikView.
Could you please tell me how to convert snowflake schema to star schema without using join and concatenate?
Go to Solution.
Without seeing your data model it's difficult to say though I'd advise you overcome your aversion to Joins and concatenations
One alternative may be to move keys from snowflaked tables to your fact table
Another may be to use Applymap to move fields from snowflaked tables to star schema dimensions
Perhaps by using mapping tables and applymap to move data from the outer levels of your model nearer to the fact table.
Try these blogs for more info
Don't join use applymaphttps://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592
Applymap Is it so wronghttps://www.quickintelligence.co.uk/applymap-is-it-so-wrong/
Thank you Marcus