Two concadinate two columns values datatable without looping

My dt is
A B
456 mygh
665 dghf

Output i want

A B C
456 mygh 456mygh
665 dghf 665dghf

please help me out

Hi @brindhaS
as Build Datatable activity
add C

and use add data row and give the values as {row("A).ToString+row(“B”).ToString}
use output datatable and print the datatable

then use write range

Thanks
AshwinS

without looping i what that data

@brindhaS

  1. Use Read Range activity to read the data from excel file and will give you output as DataTable and say ‘inputDT’.

  2. And then use ForEach Row activity to iterate that DataTable.
    ForEach row in inputDT
    row.Item(3) = row.Item(1).Tostring + row.Item(2).Tostring

  3. And then use Write Range activity to write into excel file and pass inputDT to it.

Is there is way to concadinate without looping

Hi @brindhaS

Check this

Thanks
Ashwin S

1 Like

Thanks its working

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