How can I process all the "Name of results Save" column's rows for a date variable (like yest date) using Excel query?

Help Studio
1

image

P.S> today’s date is 30-04-2022
yest date is 29-04-2022

Update: I’ve reached this stage…if anybody can help further
Book2 (1).xlsx (9.8 KB)

2

Hello @anjasing ,

Cn you make it more clear? Do you want just to get the Todays Date and yesterdays date or you want to categorize the Date of Save?

3

I want to process all the rows of “Name of results save” column for a single date for e.g. for 29-04-2022

4

You can make a filter of Datatable by the date. Then you will get the list of items. You can loop through it and process

5

Can you please help with the same. It’s urgent??

6

@anjasing

Check as below for your reference

Hope this may help you

Thanks

7

I’ve tried this but it’s output is not coming correctly as expected.

8

Could u plz check on the update I’VE mentioned in the post

9

DtFilter.zip (68.1 KB)
Use this workflow, Just change excel file location.
Please mark it as solved if you found this useful.

1 Like
10

Thank you sooooo much It worked :slight_smile:

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.