How to extract odd column index?

#1

Hi everyone,
I have a sample table that I need to extract only odd index columns y because column name may be change next time.how to do that.can anyone help…

Thanks in Advance
Krishna reddy

#2

Hi,
assign a variable for the first column and then keep on incrementing the value by 2.Then give the variable to the read activity .

#3

Thanks @vishal.kp for the response…

image
image.png1920×1080 159 KB

this is my sample html table i have to extract columns using the index…
image
image.png1920×1080 241 KB

i have done like this but it is giving only first row…
how can i make to extract all rows…

Thanks
Krishnareddy

#4

Can you share the workflow please.

#5

Main.xaml (10.2 KB)
@vishal.kp see once

#6

Cant open it buddy. Your currently working in older version. I am not able to open.

#7

am working on latest version 2019.8 only @vishal.kp

#8

Hi @vishal.kp,
So, for that

  1. read range excel sheet. —> DT (DataTable variable)
  2. assign cols = (DT.Columns.Count/2) —> taking half of Column Count
  3. use Remove Data Column activity in while loop by specifying Column Index.
    condition —> iteration <= Math.Round(cols)
    where iteration = 1
  4. increment iteration variable.

I’m attaching my sample workflow, so that you’ll get the better idea.

OddColIndex.zip (19.3 KB) :slight_smile: