Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Issue after Cross Tab Tool

Mahendra1997
メテオロイド

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).

 

Screenshot 2024-03-28 175253.png

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

3件の返信3
alexnajm
17 - Castor
17 - Castor

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.

Mahendra1997
メテオロイド

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
17 - Castor
17 - Castor

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.

ラベル
トップのソリューション投稿者