I now have a column (Column1.properties) with "list" in it:
In the list 18 keys with 18 values should be stored.
I tried extracting them like this AdCustomColumn1 = List.First([Column1.properties]) AddCustomColumn2 = List.First(List.Skip([Column1.properties],1)) AddCustomColumn3 = List.First(List.Skip([Column1.properties],2)) etc
But then something goes wrong: If a record is missing one of the keys, another key, which is in the record, is displayed:
I want every key, with their value, in the same column