title: Convert record with Power Query and JSON
body: <p>I'm using Power Query on Excel 2013 to convert an huge JSON file (more than 100Mb) to plain excel sheet.</p>
  
  <p>All the fields except one are converted correctly but there is one specific field that is recognized as record. All other fields have a fixed text value or values separated by comma, so the conversion is pretty easy, this field inside has a JSON record structure so "Field" : "Value".</p>
  
  <p>This is an extract of the file:</p>
  
  <pre><code>    {
      "idTrad": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
      "images": {
          "1": "SE1.JPG",
          "2": "SE2.JPG"
      },
      "date": "2018-09-22",
      "category": "MD",
      "value": "Original text",
      "language": "IT",
      "contexts": [
          ""
      ],
      "label": "Translated text",
      "variantes": "1,23,45,23,32,232,2315,23131",
      "theme": [
          "XX_XXX"
      ]
  }
  </code></pre>
  
  <p>The problematic field is "images" because it's recognized as a record, in the resulting table I have this situation:</p>
  
  <p><a href="https://i.stack.imgur.com/KFL1b.png" rel="nofollow noreferrer">[1]: https://i.stack.imgur.com/EnHow.png</a></p>
  
  <p>My query so far is:</p>
  
  <pre><code>    let
  
      Source = Json.Document(File.Contents("filename.json")),
  
   #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
  
      #"Column1 développé" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"value", "contexts", "theme", "variantes", "category", "label", "language", "idTrad","images", "date"}, {"Column1.value", "Column1.contexts", "Column1.theme", "Column1.variantes", "Column1.category", "Column1.label", "Column1.language", "Column1.idTrad","Column1.images", "Column1.date"}),
  
      #"Valeurs extraites" = Table.TransformColumns(#"Column1 développé", {"Column1.contexts", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
  
     #"Valeurs extraites1" = Table.TransformColumns(#"Valeurs extraites", {"Column1.theme", each Text.Combine(List.Transform(_, Text.From), ","), type text})
  
  
  in    
  
      #"Valeurs extraites1"
  </code></pre>
  
  <p>I would like to have in the images field a text rappresentation of the record so something like "1: SE1.JPG, 2: SE2.JPG", any ideas?</p>