Is it possible to present the data from first table as shown in second table using BI Report?
Summary:
This is the sample data we have and need to present as shown n Table 2
****_ID | ACTION_CODE | REASON_CODE | PERSON_ID | EMP_TYPE | ****_SEQ | EFF_DATE | PRIMARY_FLAG | STATUS | LAT_CHN |
|---|---|---|---|---|---|---|---|---|---|
300000016033156 | LEAVE_BEGIN | BENEFITS | 100000000152363 | E | 2 | 11/20/2021 | Y | ACTIVE | Y |
300000016033156 | LEAVE_RET | BENEFITS | 100000000152363 | E | 2 | 12/16/2021 | Y | ACTIVE | Y |
300000016033156 | LEAVE_BEGIN | BENEFITS | 100000000152363 | E | 2 | 10/9/2023 | Y | ACTIVE | Y |
300000016033156 | LEAVE_RET | BENEFITS | 100000000152363 | E | 2 | 11/10/2023 | Y | ACTIVE | Y |
Table2:
****_ID | ACTION_CODE | REASON_CODE | EFF_DATE | ACTION_CODE | REASON_CODE | EFF_DATE | ACTION_CODE | REASON_CODE | EFF_DATE | ACTION_CODE | REASON_CODE | EFF_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
300000016033156 | LEAVE_BEGIN | BENEFITS | 11/20/2021 | LEAVE_RET | BENEFITS | 12/16/2021 | LEAVE_BEGIN | BENEFITS | 10/9/2023 | LEAVE_RET | BENEFITS | 11/10/2023 |
Content (please ensure you mask any confidential information):