Transpose data (merging values...)

[#1]

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!

[jvitantonio]

Table1:

Load * FROM table1;

Inner Join (Table1)

Load * from Table2;

[jagan]

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

[#4]

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.