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

 

Properly looks something like this

 

Table =Table.FromRecords(data1, {"dataComplete", "finishTime", "hostName", "jobExecutionId", "jobExecutionNumber", "jobFinishedEventId", "jobInstance", "jobQueuedEventId", "jobStartedEventId", "queuedTime", "ran", "resultCode", "startTime", "track"}, {"dataComplete", "finishTime", "hostName", "jobExecutionId", "jobExecutionNumber", "jobFinishedEventId", "jobInstance", "jobQueuedEventId", "jobStartedEventId", "queuedTime", "ran", "resultCode", "startTime", "track"}, MissingField.UseNull )

 

Hope this helps you

 

/Erik

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