How to add suffix Number

[nikhil.patil]

Amending the line with Suffixing the existing invoice #
dummy Number e.g 123456
adding Number of last Character in uipath 123456_A in data table row update

dummy column

[Steven_McKeering]

Hi @nikhil.patil

You can update the a row’s value by:

• Reading in the datatable (if not already)
• Then using a for each row and and assign. Like this:

Left Assign:
CurrentRow.item(“ID”)

Right Assign:
CurrentRow.item(“ID”).ToString + “_A”

Note: “ID” is the name of the column we want to update.

Before:

After:

Sample workflow for you. Main.xaml (8.2 KB)

Hopefully this helps

Cheers

Steve

[Rahul_Unnikrishnan]

Hello @nikhil.patil

Do you need to modify the row value and to write somewhere in the excel??

If just to append the value you can use as below.

CurrentRow(“columnname”).ToString+”A”