Filtering columns and calculating

Help Activities
, ,
1

Hello All,
I have an excel file with 473 columns, Here I need to filter 30 columns based on yesterdays date in one of the column and also adding one more column which is not in the excel sheet. And need to calculate the difference of dates after filtering. Here workflow is running but unable to fetch data.
Please help me with this.

2

Hi @ISBS_ROBOT

Please take a look at this condition:

If 
column.ColumnName = "DateColumn" AndAlso DateTime.Parse(column(0).ToString()).Date = DateTime.Now.AddDays(-1).Date 
Then
    filteredDataTable.Columns.Add("DateColumn")
End If

Hope this helps,
Best Regards.

3

@ISBS_ROBOT

Please provide more details of what you tried and which all columns to be filtered and a dummy input and output would help

cheers

4

There are 473 columns in excel I need to pick 30 columns which are not in order. Apart from 30 columns if 31st column contains yesterdays date then those 30 columns need to be filtered.

5

@ISBS_ROBOT

Please provide a sample input and output

Cheers