Forum Discussion
Obsolete Hierarchie cannot be dismissed
Hi Guys I have the following challenge. I'm getting the data via REST from our DMS system so I can't change the format of the input. I get the data in json or xml format, below I will show the ch...
I found a work around which works.
1) I generated an index column.
= Table.AddIndexColumn(#"Erweiterte result.data.map.value", "Index",1)
2) I duplicate the query
3) I add another column with the index plus 1 in one query
= Table.AddColumn(#"Gefilterte Zeilen2", "Entry.Index", each [Index] + 1)
4) I joined both tables on the Index to Entry.Index
= Table.NestedJoin(#"Umbenannte Spalten", {"Entry.Index"}, Maeppchen_Aenderungen_values_Hilfstabelle, {"Index"}, "Maeppchen_Aenderungen_values", JoinKind.LeftOuter)
5) I disabled all columns I don't need
However this seems like a very inelegant way of doing it.