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 eac...
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.
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;
 
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
