Forum Discussion
Populating a Matrix from a Table
Re: Re 1 — Yes, and the volume of information gets "better", as you will see in my responses to your notes.
Re: Re 2 — You will see the problems in the second attached workbook. result2 is the (intententional) cause of the duplication, not involved in prevention of such. The LENgth functions are just another way of checking for empty strings.
If your Flight + Match combinations are unique, you won't get "contradictory results" by changing boat/team/skipper names. (But rematches late in the regatta would be a problem, which we've not discussed.)
Re: Smokey and the Bandit — No, I never knew that, as I did not watch those movies.
create temp table aa as
select f01,f02,f03,f06,f04 from Sheet1 group by f01,f02;
create temp table bb as
select * from aa union all
select f01,f02,f06,f03,iif(f04='L','W','L') from aa;
select * from bb order by f01,f02;
cli_create_two_dim~bb~f06~f04;
select * from bb_two_dim;
select * from Sheet1;
create temp table aa as
select f03,f06,'<div style="background:'||case f01 when 1 then 'Grey' when 2 then 'red' when 3 then 'Yellow' else 'White' end ||'">'||f04||'</div>' o from Sheet1 union
select f06,f03,'<div style="background:'||case f01 when 1 then 'Grey' when 2 then 'red' when 3 then 'Yellow' else 'White' end ||'">'||f05||'</div>' o from Sheet1;
//select * from aa;
cli_create_two_dim~aa~f06~o;
select * from aa_two_dim;
only use one column result f04:
select * from Sheet1;
create temp table aa as
select f03,f06,'<div style="background:'||case f01 when 1 then 'Grey' when 2 then 'red' when 3 then 'Yellow' else 'White' end ||'">'||f04||'</div>' o from Sheet1;
cli_create_two_dim~aa~f06~o;
select * from aa_two_dim;