Pivot data by desired columns

[dlesny]

Hello

Would it be possible to achieve pivot solution like that? So I have data normalized and can easily create Pie Chart in Tableau. I would very much appreciate the help.

So the pivot by Steps Passed, Failed, Skipped, Pending, Undefined:

#Feature StepsPassed StepsFailed StepsSkipped StepsPending StepsUndefined StepsTotal ScenariosPassed ScenariosFailed ScenariosTotal FeaturesDuration FeaturesStatus AT Job Name Test cases for Matching 8 0 0 0 0 8 1 0 1 2.843 Passed QS_Test_Automation_ITVT Test cases for Standardization 6 0 0 0 0 6 1 0 1 3.277 Passed QS_Test_Automation_ITVT

It pivots by Steps Values: Pivot Field Name Pivot Field Value StepsTotal #Feature FeaturesDuration FeaturesStatus AT Job Name StepsPassed 8 8 Test cases for Matching 2.843 Passed QS_Test_Automation_ITVT StepsPassed 6 6 Test cases for Standardization 3.277 Passed QS_Test_Automation_ITVT StepsFailed 0 8 Test cases for Matching 2.843 Passed QS_Test_Automation_ITVT StepsFailed 0 6 Test cases for Standardization 3.277 Passed QS_Test_Automation_ITVT StepsSkipped 0 8 Test cases for Matching 2.843 Passed QS_Test_Automation_ITVT StepsSkipped 0 6 Test cases for Standardization 3.277 Passed QS_Test_Automation_ITVT StepsPending 0 8 Test cases for Matching 2.843 Passed QS_Test_Automation_ITVT StepsPending 0 6 Test cases for Standardization 3.277 Passed QS_Test_Automation_ITVT StepsUndefined 0 8 Test cases for Matching 2.843 Passed QS_Test_Automation_ITVT StepsUndefined 0 6 Test cases for Standardization 3.277 Passed QS_Test_Automation_ITVT

[mborriero · Accepted solution]

Hi @dlesny,

Yes, it is possible. You would need to use two select tool, in one you can select the field feature and the other that you want to pivot, instead the other select will keep the other information.

Then, you can pivot the field that you like and join back the other on the field feature.

FInd my solution attached, I hope it works.

[dlesny]

Awesome, Thank you :)