Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Transpose and pivot columns?

Hi all,

 

I have a table with the dates "above" the actual table. Like the image below

I want to have the dates in a column next to the columns customer id, name, last name and age. 

I have tried to transpose, unpivot and pivot the table, but it won't work.

 

Can someone help me?

Thanks!

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi Anonymous ,

     

    If the two dates ALWAYS appear in the first two rows of the table, then you can use the following as new custom column calculations:

     

    // First date
= previousStepName[Column3]{0}

// Second date
= previousStepName[Column3]{1}

     

     

    Pete

4 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi Anonymous ,

     

    If the two dates ALWAYS appear in the first two rows of the table, then you can use the following as new custom column calculations:

     

    // First date
= previousStepName[Column3]{0}

// Second date
= previousStepName[Column3]{1}

     

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Pete,

       

      It gives an error as below:

      We cannot convert the value #date(2018, 1, 22) to type List.

       

      Could you help me with this?

      • BA_Pete's avatar
        BA_Pete
        Super User
        3 years ago

         

        Apologies. I forgot to add the reference to the name of your previous query step.

        I've updated my original response to include this.

         

        Pete