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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_5
Contributor II
Contributor II

Which is the better performing solution and how should I continue?

Hello everyone,

I want to do a report about the usage of construction machines.

As you can see on the Pictures (in the attachment!) I'm having solution 1 and solution 2.

Solution 1 is already finished with three tables (API Call E2, E7 and E8) which each one represents a whole REST-API call (dont mind the E7_items_u3_consumption table).

Solution 2 is only made for the REST-API call E7.

Later I should also join those tables with some SAP-Cost data by the serialnumer of the construction machines.

Now my question:

Which one is the better performing solution (especially if I join I it with the SAP-Data) and why?

My next question would be: 

How should I continue? For example in solution 1, should I join those three tables (which join left, full join?) to one BIG table?

 

Kind regards and thank you in advance for your solutions

 

Thomas

 

Solution 1:

Solution 1Solution 1

 

Solution 2:

Solution 2Solution 2

 

Labels (2)
0 Replies