topic Re: match two tables in QlikView

match two tables

Wed, 11 Mar 2015 10:20:05 GMT

Hi please help me,

i have two tables

1. Date/KST/value

2. KST/value

the Problem is that in table 2 are only value from exact one KST (1747)

and in table 1 this KST exist with the sum of table 2

my Problem is to create a Pivot in which the rows of the table 2 are shown in teh same column like the other values from table 1 kst

hope u can help me

Re: match two tables

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:23:09 GMT

I'm afraid I don't understand your question. Can you explain it with example records? Or post a qlikview document that demonstrates the problem?

Re: match two tables

aveeeeeee7en — Wed, 11 Mar 2015 10:30:34 GMT

Requirement not clear....???

Re: match two tables

Wed, 11 Mar 2015 10:32:16 GMT

Tabel1 Table2

KST value KST value

1740 500

1741 700

1742 800

1747 4000 1747 1000

1747 1000

how can I MATCH THESE TWO TABLES AND MAKE ONE PIVOT?

Re: match two tables

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:38:11 GMT

Table1:

LOAD Date, KST, value FROM ...

Table2:

LOAD KST, value as value2 FROM ...

Then add the fields as necessary to your pivot table.

Re: match two tables

Wed, 11 Mar 2015 10:43:58 GMT

the Problem is that i have then the value double instead of 4000 , 8000 for KST

Re: match two tables

Gysbert_Wassenaar — Wed, 11 Mar 2015 10:55:14 GMT

What exactly do you want to see in the pivot table?

Re: match two tables

Wed, 11 Mar 2015 11:01:26 GMT

i want to replace the one value from kst 1747 from table 1 with the rows from table 2

the prob is that the sum of KST 1747 in table 1 is exact the sum of KST 1747 in table 2

Re: match two tables

puttemans — Wed, 11 Mar 2015 11:01:53 GMT

Hi there,

You first load individual KST from Table2

Then you load Table1, but you do not load the KST from Table2 that are in Table1

Then you concatenate Table2

Then you can make the pivot table on your original data.

Re: match two tables

Gysbert_Wassenaar — Wed, 11 Mar 2015 11:03:07 GMT

Replace is not see. What do you want to see in your pivot table? What end result do you want to see?

Re: match two tables

Wed, 11 Mar 2015 11:13:28 GMT

ok can u say how i can load the table 1 without the KST 1747 ?

Re: match two tables

puttemans — Wed, 11 Mar 2015 11:16:17 GMT

After the load statement, you add a where-clause :

FROM .....

WHERE KST <> 1747;

Re: match two tables

Wed, 11 Mar 2015 12:36:56 GMT

thanx a lot