Delete row activity /

[Happydayyy (22035153d)]

If there only have 6 row, it is supposed there is 1-6 in column A, I need to delete the 7.

After I set a variable of Lastrow and add delete row activity, there is a error appear.

Can anyone help me to solve it?
My workflow:
FA final + delete duplicate + number problem.xaml (71.7 KB)

[lrtetala (Lakshman Reddy)]

Hi @Happydayyy

Try this it is working

Output:

Regards,

[juan.porras1 (Juan Porras)]

Hi @Happydayyy,

I just ran the workflow and worked for me. Try re-creating the variable or create a new assign activity and assign the Lastrow.toString to a new string variable.

Juan P.

[Happydayyy (22035153d)]

This errror occur while running the robot

Workflow:
FA final + delete duplicate + number problem (try).xaml (70.6 KB)

[lrtetala (Lakshman Reddy)]

@Happydayyy

Replace the Use Excel File activity to end of the workflow

[Happydayyy (22035153d)]

Should I need to remain the remove duplicate activity?

[lrtetala (Lakshman Reddy)]

@Happydayyy

Based on your process you will keep that else move to the end of the workflow

[Happydayyy (22035153d)]

can you demonstate a whole picture for me to help me to cope with this problem? Thanks you so much!

[Happydayyy (22035153d)]

There is an error occur as well if use assign activity

[lrtetala (Lakshman Reddy)]

@Happydayyy

I have made some change please try this

FA final + delete duplicate + number problem (try).xaml (73.0 KB)

[Happydayyy (22035153d)]

Thank you so much, the robot is work but the output sheet finally be like that:

I don’t know why the number will keep running after 6, may i ask how i cope with this issue?

FA final + delete duplicate + number problem (try).xaml (70.5 KB)

[Happydayyy (22035153d)]

when I open yr workflow, an error occur…

[Happydayyy (22035153d)]

Thank you so much, the robot is work now when i follow yr screenshot!