Forum Discussion

adrien1804's avatar
adrien1804
New Member
3 years ago
Solved

Parsing JSONs files from a folder

Hi Power BI Community,   I'm parsing JSON files from a folder and they could have different architectures on the second layer in the hierarchy for one of the four first items.   I succeeded to ma...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi adrien1804 ,
    if this needs to be dynamic (at the cost of performance), then you could use the following syntax:

    Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(Table.Combine(#"Removed Other Columns1"[Transform File]))),

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi adrien1804 ,
if this needs to be dynamic (at the cost of performance), then you could use the following syntax:

Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(Table.Combine(#"Removed Other Columns1"[Transform File]))),