Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Need help! Trying to build a workflow to use crosstab for multiple fields

 

Original DataSet

 

Interview CodeInterview StatusCandidate NameCandidate Email AddressPosition IDManagement LevelEvaluator NameEvaluator Email AddressEvaluation Completed TimestampCandidate RecommendationEvaluation Status
Pmatrtv-h6zhzfCompleteCandidateCandidate@gmail.com2521178Senior AnalystEvaluator 1evaluator1@gmail.com2023-03-07 12:53:48 ESTYesCompleted
Pmatrtv-h6zhzfCompleteCandidateCandidate@gmail.com2521178Senior AnalystEvaluator 2evaluator2@gmail.com2023-03-08 12:53:48 ESTYesCompleted
Pmatrtv-h6zhzfCompleteCandidateCandidate@gmail.com2521178Senior AnalystEvaluator 3evaluator3@gmail.com  Evaluation Pending

 

 

Desired Result

 

Interview CodeInterview StatusCandidate NameCandidate Email AddressPosition IDManagement LevelEvaluator 1 NameEvaluator 1 EmailEvaluator 1 Completed timestampEvaluator 1 candidate RecommendationEvaluator 1 Evaluation StatusEvaluator 2 NameEvaluator 2 EmailEvaluator 2 Completed timestampEvaluator 2 candidate RecommendationEvaluator 2 Evaluation StatusEvaluator 3 NameEvaluator 3 EmailEvaluator 3 Completed timestampEvaluator 3 candidate RecommendationEvaluator 3 Evaluation Status
Pmatrtv-h6zhzfCompleteCandidateCandidate@gmail.com2521178Senior AnalystEvaluator 1evaluator1@gmail.com2023-03-07 12:53:48 ESTYesCompletedEvaluator 2evaluator2@gmail.com2023-03-08 12:53:48 ESTYesCompletedEvaluator 3evaluator3@gmail.com  Evaluation Pending

 

 

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora

Hi @darshika_bhatt12345 ,

Here is one way of doing this.

Field names are not exactly the same as your desired result.

If you do not care much, this workflow should work. (There is a way to fix it, but it takes a few more steps...)

 

Workflow

You can edit the field name as you like between the Transpose tool and Cross Tab tool.

Yoshiro_Fujimori_0-1681102998473.png

 

Thank you @Yoshiro_Fujimori  This is helpful definately. 

 

My data set actually has several identical rows so I might need to build a group first maybe. 

Labels