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 wa...
Anonymous
I think you can add a step in the PQ which is filtering that column
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?
Filtering it did work actually. I was doing something wrong. Thanks!