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

[paulyeo11]

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 ?

[#2]

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

Please share your data model.

[paulyeo11]

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 ?

[#4 · Accepted solution]

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

[paulyeo11]

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

[#6]

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

[paulyeo11]

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.

[#8]

Hi Paul,

Find attachment..

If you need further clarification feel free to reply..

[paulyeo11]

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

[paulyeo11]

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