Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple IDs

So I have a table containing lots of data about tickets. There are multiple IDs in this table. The meaning of these IDs are stored in another table (all in the same table). Example data table 1 ...
  • ziying35's avatar
    ziying35
    6 years ago

    Anonymous 

    Try this:

    // Table1
let
    Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("i65WCslMzk4t8XRRsjLUUfIsLi5NDaksSAXzgksSS0qLlayMa3WQ1RnhUmeOqs4YRZ0xQp0JqjoTFHWWyPbGAgA=", BinaryEncoding.Base64),Compression.Deflate))),
    trans = Table.TransformColumns(Source, List.Transform(List.Skip(Table.ColumnNames(Source)), each {_, (val)=> fx(Table2, _, val)}))
in
    trans

// fx
(tbl, item, val)=> tbl[Label]{Table.PositionOf(tbl, [Property=item, Value=val], 0, {"Property", "Value"})}

// Table2
let
    Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("i65WCijKL0gtKqlUslLyLC4uTQ2pLEhV0lHySUxKzQGKBRRl5pWkFgFFwhJzSlOVrAxrdQhqckpMzi4tQOgxJkJPcGJOajFCiyWaluCSxJLSYiT1fqnluC3AUO2cn1uQk1qSitBiQkhLeGJmSWZeuoJzaXFJfi5yEJjXxgIA", BinaryEncoding.Base64),Compression.Deflate)))
in
    Source

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

create two tables from table2-->1.Status 2. Issue type 
then join(merge) these table separately on the basis of status and issue type one after another and fetch required column and delete others.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

Is this a futureproof solution? The data gets refreshed every day, will it automatically update the data for me then?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    yes, I have shared the code you can use that one it will help  you

    to get the desired result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 

      Thanks, is there a way to do this in the ribbon as well? The data in the tables is quite bigger and doing it in the ribbon would be easier I think.