You can Assign a String variable as strKey = “LIMIT_2021024_”
Now create a Int variable as intIndex and assign it as 1
Build a Datatable as External_Key column Name and create a Datatable variable let’s say dt_Key
Use DoWhile Loop and in the condition you can write as Index <> Your number
Inside the Dowhile you can add a Add row and In Datarow write it as
strkey + intIndex.ToString.padleft(5,CChar(“0”))
Now use Assign activity and write as intIndex = intIndex + 1
Please , when we have a datatable that contain the column Name "Externel Key " how it will be , , because you expect that the datatable is the column ?
yes , i have a datatable wich has 62139 rows and i have an empty column “External Key” and i want to fulfil by incrementing this column by this expression " LIMIT_20221024_00001" , but i think there is no need to put a range " ( 1 , 62139) " because it will be incremented by default is it right ?
dt.AsEnumerable.Select(Function(r,i) Tuple.Create(r,i+1)).ToList().ForEach(
Sub(t)
t.Item1.item("External_key")="LIMIT_20221024_"+t.Item2.ToString().PadLeft(5,"0"c)
End Sub
)
