Remove Null values

[stj1120]

Hi, 

The data shown in the attached excel is the output generated from an Alteryx workflow. Column 1, Column 2, --- Column 6 are the values which contains the data values in an unstructured manner.  It actually extracted the data by row wise. 

I parsed the data in the actual columns now. But, got stuck in aligining the data to show without the null values for each pdf file. 

I need assistance in aligning the relevant file data of all the columns in a single row by removing the empty values and display the actual data in a single row for each pdf file. So, in total the output should be in 4 records. 

I tried to remove the nulls but, no luck. Kindly check the attached excel file and the workflow and help me with the solution. Row column, Column 1, Column 2, --- Column 6 are not required to show in the output.

Thanks & Best regards,

stj.

[binuacs]

@stj1120 try summarise tool 

[stj1120]

Hi @binuacs ,

Thank you for your help.

The desired output has not yet come. We shouldn't use Min or Max to the actual columns. We need to show all the possible relevant values of  those fields for each pdf file in a single row. 

Please check it once and help me.

Best regards,

stj.

[binuacs]

Can you upload the expected results 

[stj1120]

Hi @binuacs 

Got the solution.

Thanks,

stj.