topic Re: Link Table in QlikView

Link Table

mishraamit2485 — Sat, 16 Nov 2013 08:48:06 GMT

Hi All

I have three tables(columns) having 1(customer ID, Country ID), 2 (customer ID), 3(customer ID, Country ID) other tables are also there but these tables are forming loops, I'm having three doubts.

1) Can we created 1 link table and join all these tables with them, if yes than how

2)Can we rename the same column again and again like multiple times, is it possible.

Re: Link Table

Sat, 16 Nov 2013 09:56:12 GMT

I don't think a link table is a good fit.

First of all I would make sure the logic of what you are doing is correct:

Would it be possible to concatenate table 1 and 3, i.e. merge them into one table?

QlikView has an associative model so why not remove one of the [Country ID] fields completely? If the tables are linked there is a good chance you can remove it from Table 3 - for example - and leave it in Table 1.

Go to the QlikTips channel on YouTube and search for a video called "Creating a data model". That might help.

Re: Link Table

Sat, 16 Nov 2013 10:10:46 GMT

Hi,

You can enter in your script just before starting to load your tables the command: Qualify *;

By doing so, the name of the table is part of the fieldname.

Most probably your loops etc. will be gone.

Now from this point you can start to define your links.

For more info regarding the qualify statement please check the reference manual.

Regards,

Gerrit

Re: Link Table

MK_QSL — Sat, 16 Nov 2013 10:18:09 GMT

Concatenate 1st and 3rd table.... Load 2nd table and use Where Exist ([Customer ID]) at the end of the script