Please share a sample packaged workbook and i can help you achieve this
Hi Morgan sorry for the delay on this.
I understand what you are looking for and this is definitely possible.
Unfortunately i am having difficulty mapping the data in the workbook to the row/column headings you have mentioned in your initial question above. please could you help me with mapping the fields in your workbook to the headings in the above example you provide
No worries at all. In the workbook I sent all of the dimensions are just examples of the first image I sent (Profile Type - Source, Target, TaxPayer ID - Source, etc.). This is how the data is structured on my backend (Oracle DB). I am trying to get that data to look like the second image.
My end goal is to compare the source and target columns for each attribute. What I have done thus far is create individual worksheets for each attribute. This seems to be a workaround for now, but it's pretty cumbersome, and I'm expecting data sets with ~100 attributes, so this probably isn't the best way to go for the long term.
This is possible by using the pivot function
Unfortunately the pivot function is only available for Flat Files - Excel, CSV data sources.
If you are connecting to a database then you will have to pivot the data within the database or use a custom SQL query to transpose the data before you pull into Tableau