Issue after Cross Tab Tool

Question

Dear Community,

I am a beginner in Alteryx and am encountering difficulty in achieving the desired output for a specific task. Please refer to the attached screenshot illustrating the current output (Actual Output) compared to how I intend it to appear (Desired Output).

When I attempt to eliminate duplicates based on Work record IDs, I find entries for the same assignee spread across two separate rows, which is not the desired outcome. Conversely, when I use assignee ID as the basis for eliminating duplicates, I observe that certain data is missing.

I would greatly appreciate your assistance in resolving this issue. For your reference, I have also attached the workflow.

Best Regards,
Mahendra

Output File - Actual vs Desired.xlsx

POA & TEQ Work Record Status Report - Created by MS on 27 Mar 2024.yxwz

alexnajm · Answer

I'm not sure what you mean - if you remove the Work Record ID from your group by it should aggregate correctly.

If you post the file as a .yxzp so that we can actually run the app you built then we can help further. Otherwise we can't do much more since we don't have the input files located in the app. To do this, go to Options > Export Workflow.

Mahendra1997 · Answer

Hi, Thank you for your reply. Data from both the columns D & E isn't coming to C & D if I'm doing this way.

alexnajm · Answer

Your Work Record ID seems to be causing these extra rows - I would look at removing it from your configuration since you don't have it in your desired output.