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

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

      • Negi1984's avatar
        Negi1984
        Regular Visitor
        7 years ago

        Hi,

         

        I am able to get the desired result. Thanks a lot for your valuable time.

         

        Regards,

        Rajender

    • Negi1984's avatar
      Negi1984
      Regular Visitor
      7 years ago

      Hi Dale,

       

      Thanks a lot for your valuable. Its working fine now . Now no error.

       

      Regards,

      Rajender