match two tables

[#1]

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

[Gysbert_Wassenaar]

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?

[aveeeeeee7en]

Requirement not clear....???

[#4]

Tabel1                                                  Table2

KST value                                             KST value

1740   500                                            

1741   700

1742   800

1747   4000                                           1747  1000

                                                               1747 1000

                                                               1747 1000

                                                               1747  1000

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

[Gysbert_Wassenaar]

Table1:

LOAD Date, KST, value FROM ...

Table2:

LOAD KST, value as value2 FROM ...

Then add the fields as necessary to your pivot table.

[#6]

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

[Gysbert_Wassenaar]

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

[#8]

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

[puttemans]

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.

[Gysbert_Wassenaar]

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