Hello,
Please help me to join the below data
INPUT | |||
Sedol | Record date2 | Record date3 | Record date4 |
7108899 | 2022-03-29 | 2022-03-29 | 2022-03-29 |
4031976 | 2022-05-16 | 2022-05-16 | |
B1L95G3 | 2022-11-01 | 2022-11-01 | |
0287580 | 2022-12-23 | ||
BJMY6G0 | 2022-03-31 | ||
BJMY6G0 | 2022-03-31 | ||
BH6XZT5 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
Output | |||
Sedol | Record date | ||
7108899 | 2022-03-29 | ||
4031976 | 2022-05-16 | ||
B1L95G3 | 2022-11-01 | ||
0287580 | 2022-12-23 | ||
BJMY6G0 | 2022-03-31 | ||
BJMY6G0 | 2022-03-31 | ||
BH6XZT5 | 2022-03-24 | ||
2793115 | 2022-03-24 | ||
2793115 | 2022-03-24 |
What are your data prep rules? For the first row, all three Record date values are the same. Should these 3 values always be the same? Which value do you want if they are different?
Hello Chris,
It would be Record date2 that would be needed
Hello Binu,
Can you help me use the transpose tool for the attached sheet in similar way where i will get the Record date in one column instead of 3 different columns.
Your desired output listed these 2 rows, which is not Record date 2:
BJMY6G0 | 2022-03-31 | ||
BJMY6G0 | 2022-03-31 |
@Devika I don't see any date fields in your file. Please check th input file