Hi i have requirement like i have two tables one is total one is Max . i have a data in Total table as follows, now i want to get total value from total table based up on the dates. suppose as shown in the below table i have data . i want to get total value from 13-12-2023 and 14-12-2023 dates . like as shown in the last table
Total table
| Date | Time | Sum | Average | total | file name |
| 13-12-2023 | 23:23:20 | 15.8 | 33 | 48.8 | Xyz1.csv |
| 13-12-2023 | 23:23:20 | 9.69 | 10.6 | 20.29 | yy9.csv |
| 14-12-2023 | 23:23:20 | 15.89 | 32.9 | 48.79 | 123a.csv |
| 14/12/2023 | 23:23:20 | 21.78 | 31.77 | 53.55 | 23s.csv |
Now i want output as follows , i just created table with Date Max and File name columns, please suggest me code to get records from total table
Max table
| Date | Max | file name |
| 13-12-2023 | 48.8 | Xyz1.csv |
| 14/12/2023 | 53.55 | 23s.csv |
could any one please suggest me the script for this
