Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
May 17, 2024

Filter Issue

Dear Experts,

                  Greetings!

I have an issue where I need to prepare a set from input sheet to Output sheet,

In the "Input" sheet we have New Antenna Id, which can be 1,3,4,7 and each of them has a corresponding RSRP for each set( as shown as an example in Yellow, orange etc)

From this , need to create the Output, so that each Antenna Id 1/3/4/7 has their RSRP values in 4 different columns as shown below:-

 

 

Both Legacy(Excel formulae) and PQ solutions are welcome.

 

Thanks & Regards

Anupam

  • rachel's avatar
    rachel
    Steel Contributor

    anupambit1797 

     

    PQ:

     

    let
      Source = Excel.CurrentWorkbook(){[Name = "Table1"]}[Content],
      Grouped = Table.Group(Source, "New Antenna ID", {"RSRPs", each [#"RSRP (dBm)"]}),
      Sorted = Table.Sort(Grouped, {{"New Antenna ID", Order.Ascending}}),
      Combined = Table.FromColumns(Sorted[RSRPs], List.Transform(Sorted[New Antenna ID], each Number.ToText(_)))
    in
      Combined
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor

    anupambit1797 

    SQL:

    create temp table aa as
    select row_number() over ( partition by f01) grp,* from basic_to_two_dim;
    cli_create_two_dim~aa~f01~f02;
    select * from aa_two_dim;

  • Hi, I may need help on creating data and output sheet but let me figure it out first then will ask for help.

Resources