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