Forum Discussion
Create a new column with values from another column
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
- The data comes in rows set of two rows. The only stuff that differs is the values in column1. I want to have the date in one column and the text for example in another column then remove row no 2 in the set.
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