I need a a query for group of tables from current tables

Help Studio
,
1
Reference Docnum Transaction Status Comment Current Main folder
rahul 1245 T1 success bhs NOP
rahul 654 T2 suce NOP
teena 1345 T1 sbh shdj NOP
yakhs 765 T1 fai NOP
teena 9878 t2 jhsj jshj ujrm
kerthi 896775 T1 fail kkjhsg Ujrm
here it is my data refrence column was current main folder nop value are in 1 group of table and ujrm are in one group of table… i need with related data also
2

May we ask you to more clear describe your use case along with sample output data and its description.

Maybe you are asking about grouping data on a column

So we can grouping the data on Current Main folder and create for each group a datatable and return all segmented tables into a list by

Assign Activity:
TableList | List(Of DataTable)

YourDTVAr.AsEnumerable.GroupBy(Function (x) x("Current Main folder").toString.Trim).Select(Function (x) x.CopyToDataTable).toList
3

i have already worked with this query but not working ‘Exception has been thrown by the target of an invocation.’

4

what was done in detail? Please share the xaml or relevant screenshots with details. Thanks

5

image

6

the statement form above is doing this

The image shows an Immediate Window in a development environment displaying the contents of a data table grouped by the "Current Main folder" field and lists these grouped tables as TableList. (Captioned by AI)
The image shows an Immediate Window in a development environment displaying the contents of a data table grouped by the "Current Main folder" field and lists these grouped tables as TableList. (Captioned by AI)862×477 83.5 KB

When Ujrm vs. ujrm needs to be harmonized we can do:

YourDTVAr.AsEnumerable.GroupBy(Function (x) x("Current Main folder").toString.ToUpper.Trim).Select(Function (x) x.CopyToDataTable).toList

The image displays a code snippet in VB.NET that groups and manipulates data from a DataTable, including examples of entries in different groups with columns labeled "Reference," "Docnum," "Transaction," "Status," "Comment," and "Current Main folder." (Captioned by AI)
The image displays a code snippet in VB.NET that groups and manipulates data from a DataTable, including examples of entries in different groups with columns labeled "Reference," "Docnum," "Transaction," "Status," "Comment," and "Current Main folder." (Captioned by AI)869×239 49.9 KB

Refering to your output we do wonder why only 2 NOP rows are shown. However as we mentioned:

And

feel free to elaborate more on this

7

@Moulika_Kaviti1
we do feel that with the given inputs the use case is addressing data grouping and we demonstrated above a solution. Feel free to discuss it internally and may get help from @Syed_Pasha.

Can the topic be finalized and closed?
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

8

Thanks for your suggestion but i have done with different query

9

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