Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have two columns that have multiple values separated by commas:
I know I could use the function to create a new column by delimiter, but I think this would be a nightmare as the number of values changes for each row and it would be a mess.
Should I make a list from these comma separated values? How can I do that?
Thanks.
Solved! Go to Solution.
@Bamgin , split by delimiter into rows seems a better option in this data.
Thanks!
@Bamgin , split by delimiter into rows seems a better option in this data.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |