Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with a number of columns (see picture). What I want to do is create one or two new columns based on the values of Column1. I want to have the values from like rowno 1,3,5 etc in a new column, they are all dates. As you can see the rest of the data in the table are all the same so I have duplicate values except for Column1,
I've also added columns at the end, index, index with mod and sub index,
What is the best approach to accomplish this?
/Magnus
Solved! Go to Solution.
I created a new modulo column with 2 row interval. Then I created a custom column, if modulo index is 0 then get the value from Column1 otherwise set null. Then a new custom column checking if modulo index is 1 then get from Column1. After that I filled up the values for the second column. After that I filtered out the rows with modulo index = 1 🙂 The result looks like this
Hello-
I am not 100% sure what you are looking for but I thought it would be a good idea for to play around with the Pivot and Unpivot columns in the transform and modeling sections. This will likely give you the functionality you need.
Jared
I created a new modulo column with 2 row interval. Then I created a custom column, if modulo index is 0 then get the value from Column1 otherwise set null. Then a new custom column checking if modulo index is 1 then get from Column1. After that I filled up the values for the second column. After that I filtered out the rows with modulo index = 1 🙂 The result looks like this
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |