topic Re: Put Another Tables inside one table in QlikView

Put Another Tables inside one table

pgalvezt — Thu, 18 Oct 2012 13:28:07 GMT

Hi, I need to associate GTO_DIC, GTO COB And INT_SUSP Inside Cartera Table. Because I need to associate the RUT field. But Without Ssnthetcs Keys.

How can I do That?

Thanks!

Re: Put Another Tables inside one table

pgalvezt — Thu, 18 Oct 2012 13:54:15 GMT

Any Help?

Thanks!

Re: Put Another Tables inside one table

pgalvezt — Thu, 18 Oct 2012 14:55:25 GMT

Is it Possible to do that?

Re: Put Another Tables inside one table

Jason_Michaelides — Thu, 18 Oct 2012 14:59:36 GMT

Can you not just join the tables?

Re: Put Another Tables inside one table

pgalvezt — Thu, 18 Oct 2012 16:37:28 GMT

Ok. I will try to do that.

Thanks!

Re: Put Another Tables inside one table

whiteline — Thu, 18 Oct 2012 18:04:54 GMT

Hi.

I think you could just rename you Rut fields to test the connection of tables (don't affraid of synthetic keys if you know what you're doing).

Then, if everything's fine and works as expected, create a link table with two key fields (@id and a complex field calculated from @id and Rut) to avoid synthetic keys.

Re: Put Another Tables inside one table

pgalvezt — Mon, 29 Oct 2012 19:58:30 GMT

Sorry for the delay. Ok I got Sysnthetic Keys. (The final result was I expected) But I Already have @Id as Autonumber(CodComercio,Periodo) as @Id With another 5 more tables. How can I avoid this if Autonumber just accept 2 fields?.

Thank you!

Re: Put Another Tables inside one table

MayilVahanan — Mon, 29 Oct 2012 20:36:56 GMT

I think for join the tables ,you mention the name like @id in tables, so synthetic key is formed..

For avoid the synthetic key, you can just rename the field @id as @idKey in two tables..

So may be the join like this:

table1

@idkey

table2

@idkey

table3

@id

table4

@id

suppose you want to join all the tables means

table1	table2	table3	table4
@idkey	@idKey
@key		@key
	@keycombine		@keycombine

in this

use @id as idKey and @key in table1

use @id as @idkey and @keycombine in table2

From this, you cn link all table and also avoid synthetic key..

I think you understand what i try to explain to avoid it..

Re: Put Another Tables inside one table

pgalvezt — Mon, 29 Oct 2012 21:06:17 GMT

I`m sorry I forgot mentioned that I have another key within @id. The field is called Rut. When I renamed the field Rut for all 3 tables Cob,Dic and Sus (Matrix table is call cartera and has Rut). Synthetics Keys was created. Before This I had Rut_Cob, Rut_Dic And Rut_Sus. Here the SK didn't exist. But I needed the Rut. Let me try your technic and let you know very tanks.