Howto to explode 1 row to several breaking out a multi-value field.
app=ABC client=AA views=View1,View2
app=ABC client=AA views=View1,View2,View3
app=ABC client=BB views=View1,View3
app=ABC client=CC views=View3,View2,View1
I want to table that to column data:
app client view
ABC AA View1
ABC AA View2
ABC AA View1
ABC AA View2
ABC AA View3
ABC BB View1
ABC BB View3
ABC CC View3
ABC CC View2
ABC CC View1
So that I can run count on that resultant rows
app client view count
ABC AA View1 2
ABC AA View2 2
ABC AA View3 1
ABC BB View1 1
ABC BB View3 1
ABC CC View3 1
ABC CC View2 1
ABC CC View1 1
