Nested LINQ to get data from 1st datatable based on 2nd datatable filter in UiPath
This video will describe how the value in a datatable column can be swapped.
Problem statement : We have 2 excels available, 1 excel contains regional data and other contains a list of Valid Regions.
Everytime the bot runs it should only consider the valid regions to pull data from Regional Sheet.
Run the following query to get the results
(From row In dt_InputData.AsEnumerable
Let valid_regions=(From val In dt_LookupData.AsEnumerable Let reg=val.item(0).ToString Select reg).ToList
Where valid_regions.Contains(row.Item("Region").ToString.Trim)
Select row).CopyToDataTable
Code Repo : https://github.com/manojbatra071/UiPa...
#rpa #uipath #OneMinuteRPA #uipathrpa #uipathstudio #linq