Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I am trying to create a report in qlik sense. The source for this report is mix of excel and sql query output. Let me give the example.
SQL Query Output
Work Order No | Quarter | Delivery Arm | Program Name |
435 | Q1 | Service Desk | Desktop Installation |
436 | Q2 | Facilities | Staircase Cleaning |
437 | Q2 | Facilities | Car park Marking |
Excel Data
Work Order No | Quarter | Delivery Arm | Location |
435 | Q2 | Service Desk | Head Office |
436 | Q2 | Facilities | Head Office |
The excel list is static and gets locked at the start of the year. The sql query I am writing fetches the latest record from the database.
I have to write the query in such a way that the Quarter and Delivery Arm for the Work Order available in Excel should come from excel sheet but the other fields should be populated from sql query. Also, Sql data will have additional work orders. The Quarter and Delivery Arm for the additional work orders should be populated from sql query. In the above example, I am expecting this ouput.
Work Order No | Quarter | Delivery Arm | Location | Program Name |
435 | Q2 | Service Desk | Head Office | Desktop Installation |
436 | Q2 | Facilities | Head Office | Staircase Cleaning |
437 | Q2 | Facilities | Car park Marking |
Any help in this topic will be highly appreciated. Thanks
HI
just load the excel table
and than join the sql table
so something like this
load * From Excel
join
load * from sql