Forum Discussion
lleverty
Mar 06, 2024Copper Contributor
Creating a list in a chart from a spreadsheet of data
I have a spreadsheet of options for student classes that looks similar to this: Name A B C D 1 X X X 2 X 3 X X 4 X The numbers represent the ...
- Mar 06, 2024
peiyezhu
Mar 06, 2024Bronze Contributor
sql:
//select * from who_take_classes limit 20;
cli_one_dim~who_take_classes~1;
create temp table bb as
select Name,属性,'Item '||row_number() over ( partition by Name) item from who_take_classesunion where 数量
like 'X' ;
cli_create_two_dim~bb~item~属性;
select * from bb_two_dim;