Please help me out of this scenario for excel activities

Learning Hub Academy Feedback
, , , ,
1

Actually my exact scenario is…
Have to read the column E First cell value (i.e., E2) and based on that E2 value, need to get A2, B2, C2, D2, F2, G2, H2, I2.
After this, have to read E3 and if E2 cell value is equal to E3 cell value, then need to get only H3 & I3.
If E2 is not equal to E3 then have to read A3,B3,C3,D3,F3,G3,H3,I3. then next have to read E4 and remaining follow is same thing as above.

As of now, i have completed as below.
Step 1.Using Read range activity - stored the sheet ‘CIDF’ as outDt
Step 2.For Each Row activity- reading the Column E (row(4).ToString)

Next waiting for your suggestion for below steps
Step 3.once read the Column E2 cell value, have to find the cell position and based on this cell position, have to get next cell values (A,B,C,D,F,G,H,I) and store in variable…
Step 4.Next, have to read E3, if E3 and E2 are equal, then have to get H3, I3 values and store in variable. If E3 & E2 not equal then it should do like step 3. then E4 then E5, E6… like this in loop. it should go on. attaching the excel & workflow Book1.xlsx (10.4 KB) dummy.xaml (7.3 KB)

2

Just to give you a brief, store the previous row value in a variable and while looping, compare that with the new value. You have to change this everytime when you loop to the next value.

if that matches, inside for each row, use if to check, if matches, get only h3 like row(8) and i3 as row(9) else, row(1) and so on

3

@HareeshMR Actually we dont know the cell position for column E, we need to find the cell position based on column E cell value. so once cell position is found then we need to get the cell value of A_,B_,C_,D_,F_,G_,H_,I_. like this flow, it should get next cell value then that cell position then remaining cell position and value like above.

4

I don’t understand this @baalajee_k. It is column E and you don’t know in which row data exists right?

5

Actually using row(4).ToString, i am mentioning its column E. using For each activity, it will read the cell value of E2, E3, E4, E5 and it goes… but while reading E2, i want get the cell value of A2, B2, C2, D2, E2… I2. after completion of this reading this row. then it have to read E3 cell value, then have to read A3,B3,C3,D3,E3…I3. so here, in looping, it will read every cell value of column E one by one but not the cell position. so based on cell position, i should get the values of A,B,C,D,F,G,…I, so i dont know how to get the cell position of E column when it reading one cell by cell in loop, if you suggest the way of finding cell position while executing the loop. THANKS in advance

6

You are getting the row(4), I mean E value here, similarly, you can get the A value as row(1) inside the for each itself right? You don’t need cell position anymore I guess

Leaving all this aside, when you drag for each row activity, you will have index in the properties of for each row when you click on it, which will give you the index of the row you are looping at that time

7

Will check it and let u know.

8

@HareeshMR : Using For Each Row, getting cell values of A2,B2,C2,D2,E2,F2,G2,H2,I2 using row(0).ToString, row(1).ToString, row(2).ToString … so… on. but in loop, i want to compare E2 with E3. how can i achieve this. please tell me your idea for comparison of E2 & E3 or E3 & E4 or E5 & E6…like this…

9

here is my idea about that @baalajee_k . you just need to use another variable to store the previous value with the present value and after comparing , change the value of variable to the present value so that it will be the previous value for the next loop