topic Transpose data (merging values...) in QlikView

Transpose data (merging values...)

Mon, 20 Feb 2012 09:39:47 GMT

Hi,

I’m trying to transpose data from one table to another and been wanting to create a simple structure where something like this fits:

Table 1

Client	Tariff A	Value A	Tariff B	Value B
1	AAA1	1.2	BBB1	2.5
2	AAA2	2.3	BBB2	4.3

Table 2

Client	Tariff	Value
1	RS1	1.2
1	RS2	1.5
2	RS2	2.3
3	BBB1	4.5

These are two tables with different levels of tariffs but I need to have them all in one table. For each client I can have different levels of tariffs.

In the end I would like to have something like table 3:

Table 3

Client	Tariff A	Value A	Tariff B	Value B	Tariff R1	Value R1	Tariff R2	Value R2	Tariff B1	Value B1
1	AAA1	1.2	BBB1	2.5	RS1	1.2	RS2	1.5	-	-
2	AAA2	2.3	BBB2	4.3			RS2	2.3	-	-
3									BBB1	4.5

Do you have an idea how can I accomplish to create something like it?

Thank you!

Transpose data (merging values...)

jvitantonio — Mon, 20 Feb 2012 11:08:54 GMT

Table1:

Load * FROM table1;

Inner Join (Table1)

Load * from Table2;

Re: Transpose data (merging values...)

jagan — Mon, 20 Feb 2012 11:17:43 GMT

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

Re: Transpose data (merging values...)

Mon, 20 Feb 2012 11:58:11 GMT

Hi Jagan,

Thanks for your answer. Actually I'm trying a different solution because I don't want to 'close' the tariffs, every month I can get new ones and I would like them to be automatically adressed.

I'll keep thinking on it.