Two concadinate two columns values datatable without looping

Help
, ,
1

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

2

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

3

without looping i what that data

4

@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.

5

Is there is way to concadinate without looping

6

Hi @brindhaS

Check this

Thanks
Ashwin S

1 Like
7

Thanks its working

8

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