DIviding values based on column names

Learn
1

Hi,

I have an excel in below format
image

And i am dividing column C with column B using write cell
as (C2/B2), but i need to divide using using column names because sometimes A and B column may interchange ,i should divide as (value/QR) ,
can someone tell me how to do .

1 Like
2

Hello @Karthik_Kulkarni,
you can do this!

  • Use Read Range and get output as outDataTable
  • Now Use For Each Row and Pass outDataTable, Inside For Each Loop you can use Assign activity like this
    intVar = Cint(row(“value”).ToString)/Cint(row(“QR”).ToString)

Cheers
@Karthik_Kulkarni

1 Like
3

double to integer error am getting

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.