Forum Discussion

TopHat's avatar
TopHat
Frequent Visitor
4 years ago

List string values in a matrix depending on different permutation

Hi all   Screenshot of the sample source data: Sanitised sample data in usable format: UserID Day DiscountedHandset FreeTrariff Phone HasOrdered Quantity Sale 1 1 Y Y Samsu...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Please provide sanitized sample data in usable format. A screenshot is not a usable format.


TopHat's avatar
TopHat
Frequent Visitor
4 years ago

I see what you mean. 

I have updated the output now hope that's better.

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Nearly there. Now please do the same for the source data.

    • TopHat's avatar
      TopHat
      Frequent Visitor
      4 years ago

      Okay done that too now ğŸ˜Š

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        See attached for one possible solution.  Note that your data model is (mostly) accurate but rather useless for the question you are trying to answer. Instead you need to use tons of disconnected tables and crossjoins.  Might get away with using TREATAS or CROSSJOIN(,,none) - which might be necessary if you want this to scale for larger date ranges.