topic Re: Create a dulipcate table from an existing table in QlikView

Create a dulipcate table from an existing table

pandreozzi — Fri, 30 Jun 2017 18:27:38 GMT

I have an issue with a relationship that creates a loop based on my table structure. I do not have access nor control on how the tables get created or modified. I only have an ODBC connection to the DB and this is why when I add a table that needs a relationship with other tables that currently have existing relationships I get loops. I am thinking if I can duplicate the date in my table that I need to form the relationship with thereby creating two identical tables I can form two separate relationships to get the information I need. There are only three fields in this table and below is my qlikview code to access the table. I also attached an image of the loop.

The SWCUSTOMERID is used to form the relationship with the other tables that need the Vendor information from the SW_CUSTOMER table.

Vendor_Provider:

LOAD

SWCUSTOMERID AS C_PROVIDER_ID,

SWNAME AS C_PROVIDER_NAME,

SWNOTE AS C_NOTES

;

SQL

SELECT

SWCUSTOMERID,

SWNAME,

SWNOTE

FROM GPS.SW_CUSTOMER

;

Re: Create a dulipcate table from an existing table

vishsaggi — Fri, 30 Jun 2017 18:59:21 GMT

I am not sure but try this and let us know?

Concatenate Access_Circuit and Base_Circuit tables.

Rename the field [Access_ID] AS Channel_Access_ID in Challen_Port table. Do these two and run and let us know.

So something like this.

Base_Circuit:

LOAD ....,

....

FROM yourBaseCircuitSource;

Concatenate

Access_Circuit:

LOAD *,.....

FROM YourAcessCircuitSource;

Re: Create a dulipcate table from an existing table

pandreozzi — Fri, 30 Jun 2017 19:06:29 GMT

I am not sure what your trying to accomplish. Both my Base Circuit and my Access Circuit tables need to form relationships with the sw site table. I think your trying to bring those together and make a new table out of the base and access circuits. correct. If that is the case this will not work as there are other fields in those tables that are named the same and cannot overlap.

Re: Create a dulipcate table from an existing table

vishsaggi — Fri, 30 Jun 2017 19:16:18 GMT

Yes, that is what i am trying to do and once they are concatenated that one single table holds the data of Base and Access table columns with their data. And where is your SW Site table I cant see in your data model?

Else just rename your Channel_Port Access_ID field to Channel_Access_ID and run it.

Re: Create a dulipcate table from an existing table

pandreozzi — Fri, 30 Jun 2017 19:38:08 GMT

Ok. the sw site table is loaded as Vendor Provider: and needs a relationship to both the channel and access tables.

Re: Create a dulipcate table from an existing table

pandreozzi — Fri, 30 Jun 2017 19:38:46 GMT

sorry a relationship with the base and access tables

Re: Create a dulipcate table from an existing table

vishsaggi — Fri, 30 Jun 2017 19:41:03 GMT

Can you send me your new data model snapshot after doing these changes?

Re: Create a dulipcate table from an existing table

pandreozzi — Fri, 30 Jun 2017 19:42:14 GMT

I will but it won't be until Monday is that is ok.

Re: Create a dulipcate table from an existing table

vishsaggi — Fri, 30 Jun 2017 19:59:48 GMT

No problem. Once you have it just send me here.

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 12:25:06 GMT

GM Vishwarath. I looked at your suggestion and cannot see how this will work. I am uploading additional information that may help in the solution. Let me know.

Re: Create a dulipcate table from an existing table

vishsaggi — Mon, 03 Jul 2017 14:17:16 GMT

Why your Vendor Provider should be matched with Channel Port, previously in your word it was not linked either. With the data model you have is it not working,? If not what exactly is not working? Can you elaborate?

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 16:23:36 GMT

My apologies in advance. the original attachment shows the loop when I originally added the vendor table to the project and the keys that connected the vendor table to the Channel Port and Base Circuit tables. The second attachment show the relationship to one of the tables and how it should look. The access table only added confusion and I should of just sent the second attachment with the issue.

Re: Create a dulipcate table from an existing table

vishsaggi — Mon, 03 Jul 2017 16:35:24 GMT

OK so what is the issue here? Can you explain again please sorry i was little lost?

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 17:04:39 GMT

ok so when I add a relationship from the Vendor Provider table to the Channel Port table there is a relationship loop that is created and I cannot have a loosely coupled relationship as the date becomes unreliable. What I would like to try and accomplish is to have a second vendor provider table created and be able to form a relationship from that new table to the channel port table. I found one way to do this is to export the vendor provider table to a spreadsheet and create a new connection to this sheet and that works but I am trying to avoid having to maintain two vendor provider tables.

Re: Create a dulipcate table from an existing table

vishsaggi — Mon, 03 Jul 2017 17:06:06 GMT

Did you try my suggestion and the data model you sent in your Zip file does that not work for you?

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 17:10:38 GMT

I will try but I think I will loose some date with that solution due to duplicate information. Also see attachment with what I got to work by creating a separate vendor file

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 18:14:36 GMT

VIshwarath, excuse my misunderstanding but where would I add your suggestion. I am very new to application development and do not understand where to insert this. I tried earlier today and received a sql syntax error.

Re: Create a dulipcate table from an existing table

vishsaggi — Mon, 03 Jul 2017 18:48:34 GMT

Can you copy paste all the scripts you used to get to this data model? Dont send me an image just copy paste the script from your editor and paste here please...

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 18:51:34 GMT

Is there a private place I can upload this to?

Re: Create a dulipcate table from an existing table

pandreozzi — Mon, 03 Jul 2017 18:52:11 GMT

Or I can email it