Merge multiple rows into one record based on Job ID

[bpatel1]

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

[christine_assaad]

Hi @bpatel1 

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

[bpatel1]

Sorry, 

Forgot to convert in a package workflow.

TY

[christine_assaad]

Thanks @bpatel1 

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!

[bpatel1]

It worked. 

Thanks!

[christine_assaad]

@bpatel1 , I'm glad it worked. 

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