Returning result from large Excel file

[PPIM_RPA]

Address List.xlsx (10.3 KB)

ZIPS County FIPS.xlsx (2.4 MB)

Happy Thursday Everyone,

I am using the address list to search for items on the web.
The FIPS numbers are necessary for later steps in the process.
Is there a way to to use LINQ and have the bot read the FIPS file and return the FIPS number that corresponds to the ZIP code in each row of the address list file?

Thank you

[postwick (Paul Ostwick)]

LINQ doesn’t read files.

Just use the Workbook Read Range to read both into separate datatables, then use Lookup Data Table to find the value you need.

Or you could read both into datatables, then do a Join Data Table once to get a single datatable containing all the data you need.

[Mohammed_Ismail_Rahid]

Main (1).xaml (8.8 KB)
Refer the worflow above…
Thank you

[PPIM_RPA]

Thank you.
Is is possible to return the value of “FIPS” as a string that can be written into address sheet?

[Mohammed_Ismail_Rahid]

Hey @PPIM_RPA ,

Here is the workflow for your requirement.
Main (1) (1).xaml (8.8 KB)

The LINQ expression used in this:

The items under column ‘FIPS’ are converted to string and then added to the address sheet.

Expected output:

[PPIM_RPA]

Thank you. That was helpful

[Mohammed_Ismail_Rahid]

Your welcome…
Happy Automation.