Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have something like this:
And I need to change it to something like this.
I know this can be done with unpivoting but I've tried several times and I have not been able to achive it.
Solved! Go to Solution.
Hi @marami21
Please see the attached solution, its three steps using UI only.
Hi @marami21
Please see the attached solution, its three steps using UI only.
Can you please explain to me what does split column by character transition do?
Hi @marami21
If you asking how it works, its a function that iterates each "Attrbute" field, converts it into a list, scans this list for numbers 0 to 9 and splits the column if the number is found.
The below screenshot shows how to create this step.
Hello @marami21
I think what you need to do is split your original table into blocks then stack them. In the attached file there are 5 queries.
The first one just pulls in the data
The next three reference the first one (no reason to load the data again) an pull just the set of columns for that block then renames the columns
The final query stacks together the previous three
All but the final query are set to not load to the model since we only care about the final result.
My sample file is attached for you to look at.
User | Count |
---|---|
140 | |
113 | |
104 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |