Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago
      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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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