how to change the date format and how to filter the data by removing hr in it
SampleCSVFile_2kb .xlsx (12.2 KB)
sheet1 is input and sheet 2 is output
the data should filter in same sheet
Try with This LINQ expression
- Read the Excel file store it in DT variable
- Use Assign activity
Dt_Out = DT.AsEnumerable().Where(Function(x) x("Column Name").ToString.Trim.Equal("it")).CopyToDataTable
- Use Write rnage activity → pass the Dt_Out
how to change the date format .
I have to remove the last row also
how to change the date format
