Forum Discussion
Remove rows that have a null value in a specific column?
I have a column "Process Step" with qualitative data, but there are many "null" values that prevent me from pivoting the column. I get errors I can't pivot cause of NA values or blank
I do NOT want to keep rows with nulls. I want to remove these rows entirely.
How can I edit the query and removet hese rows where null exists in a specific column?
Anonymous
I think you can add a step in the PQ which is filtering that column
4 Replies
Anonymous
I think you can add a step in the PQ which is filtering that column
ryan_mayu wrote:@ryan_mayu
I think you can add a step in the PQ which is filtering that column
You can add a step to filter the column, but doing so doesn't appear to let me pivot still. I get "DataFormat.Error: Invalid cell value '#N/A'." when I try to pivot.
Anonymous
could you please provide the sample data and the expected output?