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

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

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