topic Re: SOURCE field for all my table when I using same name . it create many syn key in QlikView

SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Wed, 19 Jun 2013 23:42:44 GMT

Hi All

I have sales table big file.

It have a field name = SOURCE , to differentiate data from different country.

When I add my debt or payment table . I use same name SOURCE , IT Work fine . Since debt file is very small only have 6 col of amt owe by day.

I have another file is supplier purchase file. This file very diff from above 2 file. If I use same SOURCE field name it will create extra sync key , it is fine with me. But the load time increase 100% which I need to wait for 30 min for full load.

Any advise which allow me use same field name ?

Re: SOURCE field for all my table when I using same name . it create many syn key

Thu, 20 Jun 2013 04:23:25 GMT

I assume as you should create separate link field for avoiding sync..

Please share your data model.

Re: SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Thu, 20 Jun 2013 05:58:57 GMT

Hi Sir

Enclosed my data model , pls notice that for supplier table i dare not use SOURCE , instead i use SOURCE_SUP

Because if i use SOURCE , then it will take double amount of time to reload .

The reasons when it join with sales table SOURCE , the whole table will become vey big.

Any way i can make supplier table same name on SOURCE , yet i can have fast reload as now ?

Re: SOURCE field for all my table when I using same name . it create many syn key

Thu, 20 Jun 2013 06:07:07 GMT

Hi Paul,

For you data model, Link Table logic is best one..

Please go through this discussion

http://community.qlik.com/thread/28476

At any scenario, In qlikview between 2 tables only one key field should be there. Thats the best data model.

If you need any further clarification on linktable. Let me know

Karthik

Re: SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Thu, 20 Jun 2013 06:46:18 GMT

Hi Kar

Thank you vey much for your advise . i think you hit the jackpot.

Because i am not using SQL. and i saw one key word which is none concatenance . I think this is the track.

Am i right ?

Paul

Re: SOURCE field for all my table when I using same name . it create many syn key

Thu, 20 Jun 2013 07:10:44 GMT

Yes.. You are almost right..

One to one Link available (Right one):

1. Sales and INL8

2. Sales and Currencies

3. Sales and Ranges

4. Sales and Supplier

5. Sales and durationMap3

Multiple link between tables: (Wrong)

1. Sales and Table_G

2. Sales and ARSummary

Now you want to change field name "Source" instead of "SOURCE_SUP" in Supplier table.

It will create one more link like how sales and ar mapped.. This is the reason it creating sync key.

So I will suggest you to create new key between Sales and Table_G , sales and ARSummary, Sales and Supllier...

Karthik

Re: SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Thu, 20 Jun 2013 08:25:26 GMT

Hi Sir

Thank you for your detail explanation , i must try to make this link work.

But i don't know how to start.

I create a very simple file, which only have sales and supplier table. can you pls show me how should i link , so that both SOURCE field can have similar name.

Re: SOURCE field for all my table when I using same name . it create many syn key

Thu, 20 Jun 2013 08:55:14 GMT

Hi Paul,

Find attachment..

If you need further clarification feel free to reply..

Re: SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Thu, 20 Jun 2013 09:11:39 GMT

Hi Kar

wow you are very good , now i totally understand what you mean by link table. and i know i am able to make use of one common SOURCE name. and it make my other part of the script more simple.

Thank you very much. I need to take time to implement it.

Paul

Re: SOURCE field for all my table when I using same name . it create many syn key

paulyeo11 — Tue, 25 Jun 2013 04:26:15 GMT

Hi Kar

I have manage create link table all my table like debt , P&L , supplier , after link up it work fine100%.

and now i can view sales supplier P&L by country with out need to add filter at set analysis.

i should i learn of this 3 year back.

thank you for your sharing.

Paul