Forum Discussion
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
I have attached a formula solution. I had to convert the table on the second sheet to an ordinary range, and to convert the text values1, 3, 4 and 7 in A1:D1 to numbers.
I have attached a formula solution. I had to convert the table on the second sheet to an ordinary range, and to convert the text values1, 3, 4 and 7 in A1:D1 to numbers.
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 CombinedSQL:
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;Thanks peiyezhu , honestly I am not aware of SQL and the traditional sw computer languages.
Br,
Anupam
- You are welcome.
Please refer below sample about sql which can generate column headers at once.
https://e.anyoupin.cn/EData/?s=basic_to_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.
