How do I copy the text?

Learn Academy Feedback
#1

Hello everyone,
I’m want to copy the previous line of text to put the blank line.
I have the following information. test.xlsx (9.6 KB)

Excel4
Excel41041×574 113 KB

Thanks.
Perawat

1 Like
#2

Hello @Perawat,

You can go through this post

Cheers
@Perawat

1 Like
#3

Hi @Perawat :wave:

You can achieve this using a for each loop. Kindly follow the below steps:

  1. Read the Input Excel and store the result in a DT.
  2. Use a For Each Row activity and iterate through the DT.
  3. Create a local variable, say “Temp” and store the value of row(“Bill No”) in it.
  4. Check if the variable returns an empty string using String.IsNullOrEmpty() function.
  5. If it does, assign the value of the “Temp” variable to the row(“Bill No”) inside the ‘then’ block.

Try this and let me know if you are still facing any issues.

Cheers!

1 Like
#4

@monsieurrahul, Could you please write a workflow for me ?

1 Like
#5

@Perawat
find some starter help here:
FillUp_BlockBlanks.xaml (8.7 KB)

3 Likes
#6

@Perawat Here you go:

Main.xaml (9.1 KB)

1 Like
#7

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