Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
How to perform actions on 'every column of a table' regardless of the number and name of the columns?
I would like for example:
1) get the unique values of each column
2) get the first give values of each column
etc
Thanks!
Please find below the source table and I want to output the following lists of unique values per column. Please note I want the solution to work regardless of the table and columns!
Col1 | Col2 | Col3 |
1 | 2 | 3 |
2 | 3 | 4 |
1 | 2 | 3 |
2 | 3 | 4 |
Col1 |
1 |
2 |
Col2 |
2 |
3 |
Col3 |
3 |
4 |
do you want to combine the columns to a new table?
Proud to be a Super User!
@ryan_mayu yes or I may do additional transformations once I get these unique value lists, I thank you!
i am not good at M. However, here is a workaround for you
Proud to be a Super User!
could you pls provide the sample data and expected output?
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |