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
TopHat's avatar
TopHat
Frequent Visitor
4 years ago

Hi @lbendlin , The output that I have posted is the actual output. 

It is not a set of complete rows as there will be more combinations int the fileds "From" and "Changed to" but the first 8 rows contain actual permutations and is the right out come.

 

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 ğŸ˜Š