Need Clarification

paulwalker — Fri, 31 Jul 2015 05:58:26 GMT

Hi All,

Actually i am working on Existing Application. I have so many issues on that.

My datamodel very clumsy, almost 70+ tables.

Again we are doing scratch from data, i have many tables.

I am thinking about create one Table.

everytime is it possible to create one table using ETL process???

Please give me suggestion's..

Re: Need Clarification

sorrakis01 — Fri, 31 Jul 2015 06:01:16 GMT

Hi,

You can LOAD tables and use JOIN or Residents to create one unique table.

Regards

Re: Need Clarification

kuczynska — Fri, 31 Jul 2015 06:38:58 GMT

In that case joins and resident loads will be a great help for you. It's had to determine how complex this operation would be - 70 tables into 1?

Try to keep things as simple as they possible can be - dropping every field that was only a temp field or you don't use it at all - I would start from checking the QV Document Analyzer created by Rob Wunderlich

Search Recipes | Qlikview Cookbook

This will definitely help to determine what fields aren't used in your app and what objects are resource heavy in your front end.

My last advice - try to replace some of the joins with ApplyMap() function. If you only need to bring across a small number of columns from one table to the other - do it with ApplyMap() and drop the original tables.

Start from joining/ApplyMap() on the dimension tables and just see if that's matching your expectations. You might also notice that at the end of your work you will decide to stick with a star schema data model rather than one table - if you will search trough Qlik Community you will definitely find some articles about all pros and cons for each solution. Good luck!

topic Re: Need Clarification in QlikView

Need Clarification

Re: Need Clarification

Re: Need Clarification