Split the excel data

[UJJVAL_BHAGAT]

I want to split the data and i have a multiple data in excel file, as u can see highlighted data wat is input and output , so please give me answer

thanks

[ppr (Peter Preuss)]

Assign Activity
dtSplitResult | DataType: DataTable = YourDataTableVar.Clone()

Assign Activity
dtSplitResult | DataType: DataTable =

(From d in YourDataTableVar.AsEnumerable
From s in d("Things").toString.Trim.Split("/"c)
Let ra = d.ItemArray.Take(3).Append(s).Cast(of Object).toArray
Select r = dtResult.Rows.Add(ra)).CopyToDataTable

[UJJVAL_BHAGAT]

Please create a UiPath code for this answer

[ppr (Peter Preuss)]

the shared is UiPath Code as it will use the Assign Activity as described above (Variables, Left side, right side)

When it is about decomposing the LINQ into essential modelling we can do

Assign Activity
dtSplitResult | DataType: DataTable = YourDataTableVar.Clone()

For each row in datatable | row in dtOrigVar

• For each Activity | item in row("Things").toString.Trim.Split("/"c)
  • Add Datarow Activity
  • | DataTable: dtSplitResult
  • | RowArray: row.ItemArray.Take(3).Append(item).Cast(of Object).toArray

[vrdabberu (Varunraj Dabberu)]

@UJJVAL_BHAGAT

Please create a UiPath code for this answer

Hi @UJJVAL_BHAGAT

Below zip file should help you.

BlankProcess3.zip (153.9 KB)

Regards

[ppr (Peter Preuss)]

@ppr

the shared is UiPath Code as it will use the Assign Activity as described above (Variables, Left side, right side)

When it is about decomposing the LINQ into essential modelling we can do

Find some visuals below:

The LINQ Approach

The Decomposed Approach

[UJJVAL_BHAGAT]

then the error is “item is not decleard” in the Add data row activity

[rlgandu (Rajyalakshmi Gandu)]

@UJJVAL_BHAGAT
Sequence1.zip (952 Bytes)

Hope it works for you

[rlgandu (Rajyalakshmi Gandu)]

@UJJVAL_BHAGAT

If it works for you please mark this as solution so the loop closes.
Thanks &Regards

[vrdabberu (Varunraj Dabberu)]

Hi @UJJVAL_BHAGAT

If the solution works please mark my post as solution to close the since LINQ expressions are much faster in execution than in loops. As it is reporduced through UiPath Code in simple way and provided. Or if you have any queries let us know so that we can help you.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has found…

Regards

[ppr (Peter Preuss)]

@UJJVAL_BHAGAT

then the error is “item is not decleard” in the Add data row activity

it depends on how you have configured the loop variable:

so it is:
row.ItemArray.Take(3).Append(currentItem).Cast(of Object).toArray