Need to concatenate value with a variable value without using for each

Help Studio
, ,
1

Hello,

Var1 = www.abc.com"

Excel sheet contains column as below

image
image158×164 1.22 KB

need output as follows

image
image178×215 1.94 KB

i dont want use the for each as data is huge

need vba or linq syntax.

Thanks.
@ashokkarale @Yoichi @Anil_G @lrtetala

3

@tejas.kotharkar

first read the datable as dtInput and variable will be variable1
try the below linq in assign activity

dtOutput = dtInput.AsEnumerable().
Select(Function(row) dtInput.Columns(0).Table.NewRow()).CopyToDataTable()

dtOutput = dtInput.AsEnumerable().
Select(Function(row)
dtInput.Columns(0).Table.NewRow().ItemArray = {If(CInt(row(0)) <= 5, variable1 & “'” & row(0) & “'”, row(0))}
dtInput.Columns(0).Table.Rows(dtInput.Columns(0).Table.Rows.Count - 1)
).CopyToDataTable()

cheers!!

4

Hi @tejas.kotharkar

Can you try the below

This image shows a UiPath workflow that reads data from "Sheet2" of an Excel file, assigns a string value to a variable, processes the data with a code invocation, and writes the modified data to "Sheet3" of the same Excel file. (Captioned by AI)
This image shows a UiPath workflow that reads data from "Sheet2" of an Excel file, assigns a string value to a variable, processes the data with a code invocation, and writes the modified data to "Sheet3" of the same Excel file. (Captioned by AI)1147×593 32.2 KB

dt_Input.AsEnumerable().ToList().ForEach(Sub(row) row("Numbers Link") = var1 & "'" & row("Numbers Link").ToString() & "'")

A dialog box for invoked code arguments in a software application, showing two arguments: "dt_Input" of type DataTable with direction In/Out and "var1" of type String with direction In. (Captioned by AI)
A dialog box for invoked code arguments in a software application, showing two arguments: "dt_Input" of type DataTable with direction In/Out and "var1" of type String with direction In. (Captioned by AI)881×256 10.9 KB

Input:

An Excel spreadsheet with a single column labeled "Numbers Link" containing the numbers 1 through 6. (Captioned by AI)
An Excel spreadsheet with a single column labeled "Numbers Link" containing the numbers 1 through 6. (Captioned by AI)387×335 2.83 KB

Output:

The image shows an Excel spreadsheet with a column titled "Numbers Link" containing URLs from "www.abc.com'1'" to "www.abc.com'6'". (Captioned by AI)
The image shows an Excel spreadsheet with a column titled "Numbers Link" containing URLs from "www.abc.com'1'" to "www.abc.com'6'". (Captioned by AI)503×385 3.81 KB

Regards,

1 Like
5

@tejas.kotharkar,

Hope the solutions provided meet your requirements. Feel free to let me know if any issue.

6

Yes thanks it helped me

1 Like
7

Thank you for the reply

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.