Grouping of data

Help Studio
, ,
1

How do I group data from excel file?
sample file:
image

I want output like
18126
01598,17222,17100
18111
03671,15000

I need to loop around with sessionId, such that clientid is the comma-separated

PS: I need this as soon as possible, i am stuck at production

2

Hi.
It may be run alright using linq.
Note please.

3

Thanks,
But Actually am not good with that linq query, can you please share the sample workflow?
Struggling to write linq query
Hope you can help me!!!

4

@tejastandel007
Find starter Help here:
tejastandel007.xaml (8.4 KB)

2 Likes
5

Thanks for the help

7

@tejastandel007
I would suggest that you create for this a new topic. This has the benefit, that cases are not mixed up and researchers can easy identify case and solution.

As it is a total different case, first task will be to identify the columns (splitting by Space would not work). So lets continue within the new created topic

8

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