Using multiple datatables to fill the same excel file

Help Studio
1

I have a scenario where an Excel file contains multiple rows, each representing a unique download request identified by a distinct Request ID. The file structure looks similar to the example below.

The table displays data about report requests including dates, request IDs, statuses, download confirmations, and associated URLs, with recent entries marked as "IN QUEUE." (Captioned by AI)
The table displays data about report requests including dates, request IDs, statuses, download confirmations, and associated URLs, with recent entries marked as "IN QUEUE." (Captioned by AI)802×261 4.89 KB

My approach is to use a DataTable filter to isolate rows with the status “IN QUEUE.” For each of these filtered entries, I will search for the corresponding Request ID in another DataTable fetched from a website. This second table also contains the same Request IDs, but they may appear in a different order.

The goal is to match each Request ID from the first table with its counterpart in the second table and extract the associated URL for each request.

2

Use Join Data Table with left join. You’ll get a new datatable with all the rows from the first datatable and the matching row from the second datatable. If there is no match in the second datatable, you’ll still get the row from the first datatable but the columns from the second datatable will be empty.

3

Thank you so much @postwick for the reply. I’ll try it and let you know.