Concatenate in excel; fix the Assign tab

[Justine]

How can i rectify the formula below in the Assign to concatenate values in excel?

(CurrentRow(“Account No”).tostring+“_”+Currentrow(“Invoice Number”).tostring).Replace(" “,” ")

Attaching both the screenshot and bot for easy reference.
Extract data from invoice pdf for EBS & BSCS.xaml (26.9 KB)

[AndresTarazona]

Hi @Justine

I think it is because you are using the non-existing variable CurrentRow, your iteration variable is item, the formula should look like this:

(item(“Account No”).tostring+“_”+item(“Invoice Number”).tostring).Replace(" “,” ")

I hope that solves your issue,
Andres

[Justine]

@AndresTarazona

item

Appreciate the help! Managed to fix the Assign function but however the data was not concatenated in column D.

The following functions were used:
Read range → For Each row in datatable → write range

[supermanPunch (Arpan)]

@Justine

but however the data was not concatenated in column D.

Hi @Justine ,

You would need to update the Column in the Assign Activity inside of For Each Row

Instead of newFileName, you should use item("ColumnDName")

[Justine]

it works! thanks for the assistance!

[Justine]

thanks for the help too!