How to get the previous cell information depend on one cell in excel file

[chrisjiyiwei (jiyiwei)]

dear all,

I have a problem wanna to solve.  I have an excel file as following picture displayed. 

The Row 1 like as :
Result
A
A
B
A
A
A
B
A
A
A
A
B
A
A
A
B
A
A
A
A

how could I get the result new Row 1 like
Result
A
B
A
B
A
B
A
B

anybody could give me a help? Thanks a lot for your help !

[Yoichi]

Hi,

Hope the following sample helps you.

Sample20210618-1.zip (8.6 KB)

Regards,

[chrisjiyiwei (jiyiwei)]

hey Yoichi

Thanks a lot for your reply. I have another quesiton, if this excel has no Header , it means no row name “Result” , how i get the result .
Previously excel :
A
A
B
A
A
A
B
A
A
A
A
B
A
A
A
B
A
A
A
A

i want get
A
B
A
B
A
B
A
B

[Yoichi]

Hi,

Can you try the following steps?

1. Uncheck “Add Header” property of Read Range and Write Range activity.

2. Modify "Result" to 0 in the expression, as the following.

  dt.AsEnumerable.Where(Function(r,i) if(i>0,r(0).ToString<>dt.Rows(i-1).Item(0).ToString,True)).CopyToDataTable`

Regards,

[chrisjiyiwei (jiyiwei)]

hey Yoichi

I use some example to test , some the result is
A
B
A
B
A
B
A
B
A

the last one A . i don’t need this ,how could i change?

[Yoichi]

Hi,

Probably i don’t get your requirement correctly.
Can you elaborate algorithm you expect?

Regards?

[chrisjiyiwei (jiyiwei)]

i use
dt.AsEnumerable.Where(Function(r,i) if(i>0,r(0).ToString<>dt.Rows(i-1).Item(0).ToString,True)).CopyToDataTable`
then i write range the dt

the result is
A
B
A
B
A
B
A
B
A

not
A
B
A
B
A
B
A
B

how could I change ?

[Yoichi]

Hi,

Thank you for elaborating.

How about adding Remove DataRow activty as the following?

Regards,

[Jeroen]

I’m not sue what your use case is going to be for this process, but if you’re not always sure that the last row is going to be “A”, you could also do IF row.value = “a”, Remove, ELSE do nothing.