How to copy the value of the previous line if the current one is empty?

[goncalo.rocha]

Hello all, hope to find you well,

I am currently with an issue where I extract a excel file from a server which comes with the following format.
example:

What I need to do, is to check the value of the current cell and if it’s empty, copy the value from the previous row to the current one, I have tried to do this using a for each row in excel file and an assign activity but it did not seems to work.

Does anyone have a better idea on how I should approach this situation? autofill is not an option since I will have cells with numeric values and the autofill will increment those values.

Thank you for your time and wish you all the best.

[Divyanshu_Divyanshu]

if you are using for each use current index -1 row data you will get that

[goncalo.rocha]

so something like retrieve the current index, do a currentrow(index) if empty, assign currentrow(index-1) to a variable and write that variable into the current cell?

[Divyanshu_Divyanshu]

Yes You got it, but for last item in the datatable don’t forgot to apply condition

[ppr (Peter Preuss)]

we can fill up like done in the below-presented flow:

here we can extend and handling also the other columns

Another technique is about concatenations of part ItemArray of the datarow

[goncalo.rocha]

so imagine i have to do this for 4 columns, can I make a parallel and replicate those for row 0, 1, 2, 3 and will it work?

[ppr (Peter Preuss)]

@goncalo.rocha

i have to do this for 4 columns,

as mentioned

@ppr

Another technique is about concatenations of part ItemArray of the datarow

using take / skip / concat will help

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

[HowTo] LINQ - First Start # Concat | Append | Prepend Operator

This HowTo gives an introductory overview of the conjunction operators: Concat, Append, Prepend Introduction The conjunction operators are used to add the item(s) to a particular set of items. Concat, Append, Prepend Operator The Concat Operator combines a set of items with another set of items The Append Operator adds an item to a set of items on the end The Prepend Operator adds an item to a set of items on the begin Overview I – Input P – Processing O – Output {"A","B"} / {"…