Hello all, I have an excel file I want to move that file to another folder if “Verified” column has same value called Done [image]

[image] Harshita_Ramesh: I want to move my current excel file if all the row values of column verified is Done @Harshita_Ramesh , In that case, You could use the below Linq Query to Check if all rows of Verified Column has the value “Done”. DT.AsEnumerable.All(Function(x)x("Verified").ToStr…

How to move an excel file to another folder if a particular column has same value

Help Activities

supermanPunch (Arpan) November 1, 2022, 3:02pm 6

@Harshita_Ramesh ,

As already highlighted, it is not clear what is the Excel file that is to be moved. Also, we see that a Move is to be done only if All values of the Verified Column is Equal to “Done”.

Is it the same Excel file where we are comparing the data ?

Topic		Replies	Views
Comparing Excel with file info Activities activities , question , other	12	575	July 6, 2023
To check if a column of a excel file in a folder contains specific keyword Studio datatable , excel , uiautomation , studio , question , activities_panel	3	769	October 3, 2022
How to use for each to check excel file and use if else to move file to folder Help	11	1138	March 28, 2020
Error for move file to folder IT Automation	9	1870	March 28, 2020
Ignore file if it does not exist on DataTable Activities activities , question , other	6	1423	March 18, 2021

How to move an excel file to another folder if a particular column has same value

Related topics