Hi Team,
I have two outputs which need to be merged first and then apply certain logics. Can you pls help in part 1 which is appending/merging the 2 datasets one below the other.
Dataset 1:
contains only header
Datset 2:
contains both header and values ( the dates in the header cols are dynamic and are subject to change)
| Tabname | Rows | 2021-01-01 | 2021-03-01 | 2021-06-01 | 2021-09-01 |
| tab1 | a | 1 | 2 | 3 | 4 |
| tab1 | b | 5 | 6 | 7 | 8 |
Output:
Output to be in the below format.
1. Merge dataset 1 and dataset 2 one below the other (but ignore the headers in dataset2)
| Tabname | Rows | 10 | 20 | 30 | 40 |
| tab1 | a | 1 | 2 | 3 | 4 |
| tab1 | b | 5 | 6 | 7 | 8 |
I can proceed with render tool if this is the only output required, but after merging I need to apply certain logics again, not sure how to proceed (as after render tool I don't think I can bring in select/formula tool to apply logics)
thanks in advance.
