Extracting values from data table based on values present in another data table

Help Studio
, ,
1

Hi All,

My task is to extract values from an excel/data table based on YES/NO values present for that column in another excel/data table.

Let me elaborate, I have a data table in which data related to a product is mentioned like product Id, price, and all, and I have to push this data to the orchestrator but the condition is that for every product Id I have to pick different column values and not all. That condition is present in another data table like for a particular product Id whichever data points I have to take are mentioned in a YES/NO format. If the value is Yes I have to pick else not.

Kindly let me know the solution.

2

HI @Shashwat_Raghuwanshi

Welcome to Uipath community

  1. Use Read Range activity → Store it as DtInput

  2. Use For each row in data table activity

Inside the for each

  1. Use If activity
CurrentRow("Column name").tostring.Trim.Contains("YES")

Then → Use Add Queue Item activity and add the data in the orchestrator Queue

Else → Leave it blank

Check out the Image for better understanding

image
image874×496 33.1 KB

Regards
Gokul

3

Hello @Shashwat_Raghuwanshi

You can use the loop, for each row in datatable and filter datatable actiivty to achieve this.

in the filter datatable acitvity you need to add the required conditions and enable “Keep”. Then it will extract only the requried data as a new datatable.

Thanks