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
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!
It worked.
Thanks!
@bpatel1 , I'm glad it worked.
Would you mind flagging the post as Solved so other users can benefit from? TY!