1 BEST ANSWER
Best Answers
Hi Lorenzo,
We can use a LINQ object to get the unique records as per your requirement. You can create a new business object and add the below External References ('System.Data.DataSetExtensions.dll', 'System.Core.dll') and Namespace Imports ('System.Data.DataSetExtensions', 'System.LINQ' and 'System.Collections.Generic') on the Page Description stage of your Initialize action for the LINQ queries to work properly. Also, ensure that the language is selected as 'Visual Basic':
Once you have the updated code options as shown above, create a new action named 'Get Unique Rows' and pass two input arguments, Input Collection (Collection) and Field Names (Collection). Based on the field names that you provide the unique records will be fetched from the Input Collection. Also, set an Output parameter as Output Collection (Collection) for this action as shown below:
Add the code stage and use the below code with the input and out arguments as show:
The run results are as follows:
Input Arguments:
Output Result:
NOTE: For your use case you need to use both the fields 'A' and 'B' in the 'Field Names' collection then only it will take it in a group
You can publish the action and test the same from Process Studio. Let us know if this helps you out and please mark the answer as the 'Best Answer' if it resolves your query so that others can track the answer easily 🙂
We can use a LINQ object to get the unique records as per your requirement. You can create a new business object and add the below External References ('System.Data.DataSetExtensions.dll', 'System.Core.dll') and Namespace Imports ('System.Data.DataSetExtensions', 'System.LINQ' and 'System.Collections.Generic') on the Page Description stage of your Initialize action for the LINQ queries to work properly. Also, ensure that the language is selected as 'Visual Basic':
Once you have the updated code options as shown above, create a new action named 'Get Unique Rows' and pass two input arguments, Input Collection (Collection) and Field Names (Collection). Based on the field names that you provide the unique records will be fetched from the Input Collection. Also, set an Output parameter as Output Collection (Collection) for this action as shown below:
Add the code stage and use the below code with the input and out arguments as show:
Dim listOfFields = New List(Of String)()
listOfFields = Field_Names.AsEnumerable().Select(Function(dr) dr.Field(Of String)("Fields")).ToList()
Output_Collection = Input_Collection.DefaultView.ToTable(True,listOfFields.ToArray())
The run results are as follows:
Input Arguments:
Output Result:
NOTE: For your use case you need to use both the fields 'A' and 'B' in the 'Field Names' collection then only it will take it in a group
You can publish the action and test the same from Process Studio. Let us know if this helps you out and please mark the answer as the 'Best Answer' if it resolves your query so that others can track the answer easily 🙂
Hi Lorenzo,
We can use a LINQ object to get the unique records as per your requirement. You can create a new business object and add the below External References ('System.Data.DataSetExtensions.dll', 'System.Core.dll') and Namespace Imports ('System.Data.DataSetExtensions', 'System.LINQ' and 'System.Collections.Generic') on the Page Description stage of your Initialize action for the LINQ queries to work properly. Also, ensure that the language is selected as 'Visual Basic':
Once you have the updated code options as shown above, create a new action named 'Get Unique Rows' and pass two input arguments, Input Collection (Collection) and Field Names (Collection). Based on the field names that you provide the unique records will be fetched from the Input Collection. Also, set an Output parameter as Output Collection (Collection) for this action as shown below:
Add the code stage and use the below code with the input and out arguments as show:
The run results are as follows:
Input Arguments:
Output Result:
NOTE: For your use case you need to use both the fields 'A' and 'B' in the 'Field Names' collection then only it will take it in a group
You can publish the action and test the same from Process Studio. Let us know if this helps you out and please mark the answer as the 'Best Answer' if it resolves your query so that others can track the answer easily 🙂
We can use a LINQ object to get the unique records as per your requirement. You can create a new business object and add the below External References ('System.Data.DataSetExtensions.dll', 'System.Core.dll') and Namespace Imports ('System.Data.DataSetExtensions', 'System.LINQ' and 'System.Collections.Generic') on the Page Description stage of your Initialize action for the LINQ queries to work properly. Also, ensure that the language is selected as 'Visual Basic':
Once you have the updated code options as shown above, create a new action named 'Get Unique Rows' and pass two input arguments, Input Collection (Collection) and Field Names (Collection). Based on the field names that you provide the unique records will be fetched from the Input Collection. Also, set an Output parameter as Output Collection (Collection) for this action as shown below:
Add the code stage and use the below code with the input and out arguments as show:
Dim listOfFields = New List(Of String)()
listOfFields = Field_Names.AsEnumerable().Select(Function(dr) dr.Field(Of String)("Fields")).ToList()
Output_Collection = Input_Collection.DefaultView.ToTable(True,listOfFields.ToArray())
The run results are as follows:
Input Arguments:
Output Result:
NOTE: For your use case you need to use both the fields 'A' and 'B' in the 'Field Names' collection then only it will take it in a group
You can publish the action and test the same from Process Studio. Let us know if this helps you out and please mark the answer as the 'Best Answer' if it resolves your query so that others can track the answer easily 🙂
