Forum Discussion
Create a new column with values from another column
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 ...
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.