I have 57 columns in my data set. And I must run a groupby on each column to find out the unique values along with its Count for each column.
I am finding it harder to apply Groupby for each column.

I came across loop node. I am not even sure whether Loop is the Solution. If yes, Could you tell me how to apply it

Hi @suseearun you could potentially use a Column List Loop and perform a groupby within the loop, but it can be a bit fiddly, and also relatively inefficient (because it is a loop!)

This then returns me a table which is easy to use GroupBy on, because I can now group by the ColumnNames and get a â€śunique countâ€ť of the ColumnValues, along with a Set (which is the unique values):

Hi @suseearun, I now better understand what you were asking as I thought you simply wanted a count of the number of different values, along with a list of the different values. Its much easier to visualise once there is an example.

I think @tomljh 's solution gets you precisely what you need, so please remember to mark @tomljh 's post as the solution. That way people can see that it has been solved. thanks