Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
KundanJyothsna
Contributor II
Contributor II

convert snowflake schema into star schema

Hi everyone,

 

Can anyone nuture me in converting application from snowflake schema into star schema along with some sample data using applymap?

 

Labels (1)
4 Replies
anushree1
Specialist II
Specialist II

You can convert the snowflake to star using the join between the tables involved in snowflake.

If you can share the sample app that you are working on, I can try and help you with the join.

For Apply map sample , please refer https://community.qlik.com/t5/QlikView-App-Development/quick-applymap-example/td-p/515616

KundanJyothsna
Contributor II
Contributor II
Author

Thanks anushree for the answer. But I need to implement that using applymap instead of joins and moreover i don't have any sample app. I just needed the sample app from anyone of you.

 

 

I dont know how and where to start so as to implement it.

 

Thanks

Kundan

anushree1
Specialist II
Specialist II

Apply Map sample explanation is on the URL I sent please check

Brett_Bleess
Former Employee
Former Employee

You can also check out the following Design Blog post, that may help as well:

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-join-use-Applymap-instead/ba-p/1467592

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.