Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Transpose data (merging values...)

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!

3 Replies
jvitantonio
Specialist III
Specialist III

Table1:

Load * FROM table1;

Inner Join (Table1)

Load * from Table2;

jagan
Partner - Champion III
Partner - Champion III

Hi,

Please check the attached file for solution.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

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.