Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cannot convert value null to text - pivot

I have a reasonably complex workflow with several tables and am getting the error below. Unfortunately,  I cannot share the workbook or data.    I checked this thread but couldn't find a solu...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Anonymous ,

    According to your description, I reproduce your problem.

    If there is null in the column, after pivot the column, the same error occures.

    I think it's because after pivot, values in Column1 will be column names, but the null value cannot be used in column name.

    As a workaroud, in the replace value step, replace 0 with text "null" instead of null, directly add Double quotes “” to null in the code.

    After pivot, the error disappears.

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

According to your description, I reproduce your problem.

If there is null in the column, after pivot the column, the same error occures.

I think it's because after pivot, values in Column1 will be column names, but the null value cannot be used in column name.

As a workaroud, in the replace value step, replace 0 with text "null" instead of null, directly add Double quotes “” to null in the code.

After pivot, the error disappears.

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.