Forum Discussion

TBenders's avatar
TBenders
Helper II
10 years ago
Solved

Combining rows based on unique id, and combining information

Hi,   This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't...
Need Help
  • ImkeF's avatar
    ImkeF
    10 years ago

    Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.

ImkeF's avatar
ImkeF
Community Champion
10 years ago

This is one of my favourites :-)

 

1) Check column ID -> Mouse rightclick -> Unpivot Other Columns: This will delete the nulls

2) Check column Attribute -> Transform -> Any Column -> Pivot Column: Choose "Value" in Values Column

 

  • TBenders's avatar
    TBenders
    Helper II
    10 years ago

    Hi Imke, thanks so much for your help so far!

     

    This seems to get me part of the way there, but the resulting values (after pivot) are only 0 or 1instead of the dates.

     

    Example:

    id

    StartDate

       FollowupDate

         FinishedDate

    101     

    1

       1

       1

    102

    1

       0

       1

    103

    1

       0

       0

     

    If I change type to date, the results are not accurate, all in 1899.

     

    Does anyone know what I can try?

    • ImkeF's avatar
      ImkeF
      Community Champion
      10 years ago

      Sorry, forgot to mention that you need to turn the aggregation off: last step: Advanced Opions: Don't aggregate bofore hitting the last OK.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi ImkeF,
        I am trying to find the solution to this thread without success.
        Could you share it?