Dear all, I am trying to get the previous value of “A1” column per each row. Currently, I can’t achieve that. |Site Code|Site Name|Delivery date|Item Code|Quantity| |C0001101|Ye Moe|2/9/2020|A00002|14| |C0001101|Ye Moe|2/9/2020|A00003|28| |C00017|Test Customer|2/9/2020|A00002|4| |C00017|Test C…

Hello @Htwe_Ko_Ko_Wynn , Please find attached updated workflow. Sequence.xaml (8.4 KB)

@prakaz25 If you are trying to remove the rows with respect to the column “Site Code”, use filter data table activity.

Hi @Htwe_Ko_Ko_Wynn Better remove the Duplicate rows from Datatable & create temp variable as empty by default. In for each row you can compare every iteration value then take only not matching row

can u specify the range like for example a3:c3

Dear All, That i want to know only the previous data of “A1” Column. For example, if the Site Code is changed or not equal to previous site code, my program will entry new data in new form. These C0001101, C0001101 are in one form. the next C00017, C00017, C00017 will be in new form. Is there an…

Dear Prakaz, I tried to remove duplicates, but not working though. [image]

Hello @Htwe_Ko_Ko_Wynn , You can use following steps to get it done. (All steps should be added to For Each loop) Step 1: If condition - Add if condition to check if preSiteCode = row(“Site Code”).ToString Step 2: Then: Perform some action Step 3: Else: Enter new form data Step 4: Assign Activit…

You workflow should look something like this: [image] You may have to twist a bit but it should give you a good start.

Thanks Bhavik, Let me try that.

i still facing issue Bhavik can you please guide me more?

Excel previous row value

Learning Hub Academy Feedback

Htwe_Ko_Ko_Wynn (Htwe Ko Ko Wynn) February 25, 2020, 9:28am 9

Hi Bhavik,

Sorry for my late reply, i am not still clear on it. If it is possible can you please show me as screenshot that if u are available. Many thanks.

I want to remove duplicate rows from datatable by comparing single column

Topic		Replies	Views
How to get previous row value and compare it to the current row Studio excel , activities , studio , question , system , activities-panel	7	1932	June 2, 2023
How to get previous row value Activities activities , question , system	2	193	December 6, 2024
Excel columns comparison Activities excel , activities , question , system	5	1180	March 16, 2022
How to update value of previous row of an datatable while running through for each row activity Activities activities , question , system	2	1561	October 6, 2021
Get previous row Help datatable , excel , activities , question , system	8	3681	December 17, 2019

Excel previous row value

Related topics