Merge multiple rows into one record based on Job ID

Hi,

I am having issues with existing workflow after joining two tables in Alteryx.

I want to create only one record based on the Job ID by merging all the null values PD, PM, CM, IA columns.

I would really appreciate your help on this.

Thanks in Advance.

bpatel

Workflow

Accepted answers

Will you be able to attach your Excel file or package the workflow? TY!

Sorry,

Forgot to convert in a package workflow.

I did Transpose the data to get rid of "Nulls" then used a Cross Tab to get it in the desired format. Hope that helps. Cheers!

It worked.

Thanks!

@bpatel1 , I'm glad it worked.

Would you mind flagging the post as Solved so other users can benefit from? TY!