FILTER DATA TABLE WHERE I NEED ONLY 6 COLUMNS SCATTERED ANYWHERE BETWEEN Column A and Column K

Help Studio
, ,
1

H team,

I am in the middle of logic where I have a following table in my dt variable.

filter data table
filter data table1912×544 27.7 KB

As you can see, there are columns from A to K.

I want to filter data table such that I get only the following columns:-

filterfff
filterfff1917×363 12.5 KB

PLEASE NOTE THAT I WANT TO FILTER DATA TABLE WITH RESPECT TO THE FOLLOWING CONDITIONS:-

  1. HAVE THE VALUES (Recognized Organisation, Certificate, Issued, Expiry, Last Survey, Date)
  2. remove all the other columns,.
  3. These columns can be anywhere between Column A and Column K.
  4. I want only these 6 columns wherever they are scattered.
  5. these columns order will always remain same.

PLEASE TELL ME WHAT DO I DO IN FILTER DATATABLE TO SATISFY MY CONDITIONS>

Let me know if somthing else needed from my side.

Thanks and Regards,
@hacky

2

@mz3bel,
@GBK
@JuvRPA

Can you guys please help me on this.

3

@hacky - in excel row #1 values(columnn 0,1,2,3,…10) will be a headers?

if yes - pls ignore the row#1 and read the excel file… row#2 will be your columns for the extracted datatable (read range as A2) and you can use datatable with those specific name.

4

You can read specific cell ( A2 , B2)
If A2 = the column you don’t need so delete column (or save it in array and then for each value in array delete the column )