Hi,
I have to fetch data from database based on current date. After that, in case of multiple request for same ID it should be merged into one single row. .Example
RequestType ID Name watchlist RBcode
Core 1 A
IsWatchlist 1 True
RBCode 1 123
Core 2 B
Here we have 3 cases for same ID. Whenever the ID is matching, what I have to do is I need to update the values in the RequestType Core and make it as 1 row. Final result should be like this
RequestType ID Name Watchlist RBcode
Core 1 A True 123
core 2 B