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
Tabname | Rows | 10 | 20 | 30 | 40 |
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.
Solved! Go to Solution.
Hi @SrinivasanSugumaran ,
Since the first dataset is just header information, this is a great time to use the 'dynamic rename' tool. This tool will let you dynamically rename fields based on different criteria (formulas, first row of data, data from another source, etc). In this case you can rename the fields in dataset 2 based on the field names in dataset 1.
I've attached a sample of this. More info on dynamic rename
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |