Forum Discussion

Negi1984's avatar
Negi1984
Regular Visitor
7 years ago
Solved

How to Remove All columns Error while importing Json table

Hi All,   I want to replace all Errors messages with "NULL" in all the columns. I am import data from JSON and it is giving me error like below for mulitple columns .     Below is the cod...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Negi1984,

     

    Why not just following the built-in functions? Please refer to the snapshot below.

    How_to_Remove_All_columns_Error_while_importing_Json_table

     

    Best Regards,
    Dale

Negi1984's avatar
Negi1984
Regular Visitor
7 years ago

Hi,

 

I replace the below code with my PQ code. but its giving me another error like below :-

 

donsvensen's avatar
donsvensen
Skilled Sharer
7 years ago

Hi

 

Could you share a screenshot from your previous step ?

 

/Erik

  • Negi1984's avatar
    Negi1984
    Regular Visitor
    7 years ago

    Hi,

     

    Please find the snapshot of previous steps :-

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Negi1984,

       

      Why not just following the built-in functions? Please refer to the snapshot below.

      How_to_Remove_All_columns_Error_while_importing_Json_table

       

      Best Regards,
      Dale

      • donsvensen's avatar
        donsvensen
        Skilled Sharer
        7 years ago

        Hi Negi1984

         

        I agree with v-jiascu-msft - if you still have problems let us know

         

        Best 

        Erik