Add new column

[msalesforce777]

Hello Team,

DT contains 3 columns( unique Id, rate, action).
2 rows (row 1 - 111, 40, sale)
( row 2 - 111, 50, purchase)

If the columns (unique Id) matches then in new DT 2 new columns containing row 2 values must be added.

I.e New DT
unique Id, rate, action, new rate, new action
111 40 sale 50 purchase

Please guide with sample workflow.

Thanks

[ppr (Peter)]

One of many options would be

• join datatable activity | Join Type: left and then process the Join Result
  Story line of Join Data Table

Depending on some constraints another option could be a LINQ statement

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Sta…

[msalesforce777]

There is not another datatable, only 1 dtattable, we need to create new datatable with added columns

[devik (Devi Kandasamy)]

@msalesforce777 Hi. Build datatable for DT2 with 5 columns. Then add the assign activity for DT2 with following statement on right. Hope this helps.
(From d In DT1.AsEnumerable
Group d By k=d(“Id”).toString.Trim Into grp=Group
Let rate = grp.Select(Function (rn) rn(“rate”).toString).toArray
Let action = grp.Select(Function (rn) rn(“action”).toString).toArray
Let row = New Object(){k, rate(0), action(0),If(rate.count>1,rate(1),“”),If(action.count>1,action(1),“”)}
Select DT2.Rows.Add(row)).CopyToDataTable

[Jithesh_R]

Hey @msalesforce777 ,
Try this workflow

Main.zip (2.4 KB)

Output:

Regards,

[devik (Devi Kandasamy)]

@msalesforce777 Please find the sample workflow attached. Hope this helps.
Datatabletest.zip (2.2 KB)