Though it would be totally justifiable, thanks for not giving up on me.
Well, here's another approach that's very simple,
but you may not like how this looks.
I took the three components and concatenated them together so that it looks like "Loc | Member | Phone" using:
Then I created an INDEX() and put that as discrete on Columns Shelf, restarting every ID.
It looks like the below (I just used random numbers instead of actual names, but the gist is the same).
It can be cleaned up and labelled better.
Please see workbook v10.3 attached in the Forum Thread.
Attached too is the datasource, please do modify to make it closer to yours.
Thanks for answers to the questions.
Preliminarily, I was thinking something on the below like might help with custom sql:
That approach requires a second sheet of possible names to cross join against.
Thank you swaroop, that looked better but could you reformat that columns with out having break statements?
For example: 2XL | Ottilie | 265-194-1411 would be separate columns.
Getting into columns and in the proper order is fundamentally the difficult part.
Would be grateful if you would clarify what the end use of this table is.
Once you get them into columns, what to do you/the users need to do with it next?
Are you filtering a particular column to certain values?
Are you looking for particular combinations (if a row has a Member of John and Phone number of 123-456-7890)?
I'm continuing on the road of promoting the last method mentioned, because it will
also easily accommodate the addition of a status for each member.
I think the above method retains all the functionality needed to filter and analyze.
But with respect to getting them into columns as you want them, specifically
if it is for later downloading, I might have to say you'd be better served
using a different tool to do the transformations.
Tableau's strength as a graphical visualization tool isn't best utilized in this tabular question.
All that said, it is possibly doable using Custom SQL.
Even with Custom SQL, I still sense that it will involve merging multiple copies
of the dataset.
I will explore that.
But certainly am opening this up to other members of the community to pursue and discuss.
Hi swaroop, to follow-up how's exploring the methods going?
My apologies for long delay. Shocked at how much time has gone by.
Sorry about that.
I came across this link about dynamic pivot queries:
It sounds like might be able to do what you need it to do.
However, I am doubtful that this will work as Tableau Custom SQL.
But it possibly could. Will need a Tableau-SQL guru to weigh in on this.