Filtering Data for visualization

[woojacky]

Hi Folks, needs some advice. I have a table that look something like below

Customer Name	Label 1	Label 2	Label 3	Label 4	Label 5
Customer A	Microsoft	"blank"	Customer A	Team A	Cloud
Customer B	Team A	Redhat	On Premise	Customer B	"blank"
Customer C	Apple	Customer C	Team C	"blank"	On Premise
Customer D	On Premise	Team B	"blank"	Customer D	SUSE

Intention is that I want to be able to use slicer to filter out information and present the corrosponding data. Example

1. Which team has been servicing which customer

2. What customer has been using which product

Can anyone guide me in getting this done?
Have tried looking at https://www.youtube.com/watch?v=UvvS376vYSw but my data are all strewn in 8 different columns (label 1 - label 😎 and hence it doesn't work for me.

[woojacky]

Thanks for providing some guidance there. Had to read up exactly how does one unpivot in the first place. So just for reference for others who might encounter similar issue, below are broad steps that I've done.

1. Create an INDEX in my main table (this is to be used for table relationship at the end)

2. Create a new table

3. Duplicate the necessary columns that I need to unpivot (in my case are label, label1, label2, label3, etc), I used REMOVED OTHER COLUMNS

4. Make sure INDEX is also duplicated into this new table

5. Then choose UNPIVOT OTHER COLUMNS based on INDEX

6. Select Many to One relationship with INDEX as the unique value as reference

Tada.

[MFelix]

Hi @woojacky ,

Sorry but I lost your previous message on the notifications I got and did not answer you. But glad you were abble to figure it out.

Just an adittional hint instead of duplicate you can use the reference also.

[MFelix · Accepted solution]

Hi @woojacky ,

Best option appears to me is to unpivot this data and then try to identify on each line what is the type of data you are using and then pivot based on that new column. Do you have any list of the Teams and of the products?

[woojacky]

Yes I have a list of teams and products. How do I unpivot as the data is in my original CSV file? I was thinking of using extract if "text" but might be too much of a hassle though