Concatanate Value to Column

[NISHITHA]

Hello Team,

We have a column in Below Format in Excel File

ProjectID
2899
2898
2890

How can we concatanate value 18 to all of it

ProjectID
289918
289818
289018

Thanks team in advance

[mkankatala (Mahesh Kankatala)]

Hi @NISHITHA

→ Use Read Range workbook activity to read the excel and store in a datatable called Input_dt.
→ You can use the below LINQ expression in assign activity,

- Assign -> Output_dt = (From row In Input_dt.AsEnumerable
                         Let ProjectID = row("ProjectID").ToString+"18"
                         Select Input_dt.clone.Rows.Add({ProjectID.ToString})
                             	).Copytodatatable()

→ Then Use Write Range workbook activity to write the Output_dt to the same excel.

Hope it helps!!

[pravallikapaluri]

Hi @NISHITHA

CurrentRow("ProjectID")= CurrentRow("ProjectID").ToString + "18"

Hope it helps!!

[NISHITHA]

Thanks @mkankatala and @pravallikapaluri for sharing

Do we have any other approach

The First approach when we try then the other columns which have data is not getting displayed

[pravallikapaluri]

@NISHITHA

Can you share the sample input.

Have you tried the solution I provided .

[NISHITHA]

Test Reference.xlsx (6.2 KB)
Sheet 1

[pravallikapaluri]

@NISHITHA
Find the below zip file with your expected output

BlankProcess7.zip (45.1 KB)

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @NISHITHA

Use below mentioned Code in Invoke Code Activity!

io_dt_Input.AsEnumerable.ToList.ForEach(Sub(x)
x("ProjectID") = x("ProjectID").ToString+"18"
End Sub
)

Input & Output:

Attaching .xaml for your reference:
ConcateValueSequence.xaml (6.8 KB)

Input Output File:
Test Reference.xlsx (9.0 KB)

Workflow:

Regards,
Ajay Mishra

[mkankatala (Mahesh Kankatala)]

Could you share your Input Excel file if it doesn’t have any confidential information… @NISHITHA

Then only I can modify the LINQ Expression according to that.

[NISHITHA]

Thanks @pravallikapaluri and @Ajay_Mishra for the prompt Solution