Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
i would like to do the following;
I am looking to combine given SLA values to the table Priority from my DB.
These SLA values are not in the database and are stored in an excel sheet.
to optimize my solution i would like to skip using the excel sheet and enter these SLA values directly into qlikview script to form a new table or complement the table Priority by adding an extra row.
is this possible?
table Priority:
PriorityID | Priority Name | Severity |
---|---|---|
01 | Low | 1 |
02 | Medium | 2 |
03 | High | 3 |
Excel Sheet:
PriorityID | SLA Value (hours) |
---|---|
01 | 3 |
02 | 6 |
03 | 9 |
Desired Table:
PriorityID | Priority Name | SLA Value | Severity |
---|---|---|---|
01 | Low | 3 | 1 |
02 | Medium | 6 | 2 |
03 | High | 9 | 3 |
Hi,
Try the following:
SLA:
LOAD
* INLINE [
PriorityID, SLA Value
01, 3
02, 6
03, 9
];
Left Join(Priority) Load * Resident SLA:
Drop Table SLA;
Hope it will help.
Hi,
Try the following:
SLA:
LOAD
* INLINE [
PriorityID, SLA Value
01, 3
02, 6
03, 9
];
Left Join(Priority) Load * Resident SLA:
Drop Table SLA;
Hope it will help.