Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting repeated values on each row of the column. Below is the table. There are only 2 distinct value for Code status but it creates duplicate in column code. Also, for Primary code there is only one distinct code but it gets repeated on each row. Any idea to resolve this issue. Thank you
ID | Code | Code_Status | Primary Code |
4 | P07.03 | CPR-Full Code | STEMI |
4 | P07.03 | No CPR | STEMI |
4 | C67.9 | CPR-Full Code | STEMI |
4 | C67.9 | No CPR | STEMI |
4 | C68.9 | CPR-Full Code | STEMI |
4 | C68.9 | No CPR | STEMI |
4 | D50.9 | CPR-Full Code | STEMI |
4 | D50.9 | No CPR | STEMI |
4 | E21.3 | CPR-Full Code | STEMI |
4 | E21.3 | No CPR | STEMI |
5 | E78.5 | CPR-Full Code | VTE |
5 | E78.5 | No CPR | VTE |
5 | E86.1 | CPR-Full Code | VTE |
5 | E86.1 | No CPR | VTE |
5 | G89.3 | CPR-Full Code | VTE |
5 | G89.3 | No CPR | VTE |
5 | J21.9 | CPR-Full Code | VTE |
5 | J21.9 | No CPR | VTE |
5 | P29.12 | CPR-Full Code | VTE |
5 | P29.12 | No CPR | VTE |
Hi Ash,
Great to know that it worked for you. Please keep in mind that FOR loop on smaller set of data is fine but for larger set of data it will be very time/cpu consuming process. If possible, you may want to consider getting data ready outside of Qlik.
BR,
Vijay