Forum Discussion

peiyezhu's avatar
peiyezhu
Bronze Contributor
Oct 14, 2023
all roads to Roman.
I guess if you provide the source workbook and expected result,the discussion on the spesific automation solution can start soon.
Leighleigh33's avatar
Leighleigh33
Copper Contributor
Oct 16, 2023
I have just loaded the sample and the last sheet title summary is what i want returned from the other sheets in the workbook.
  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Oct 16, 2023

    This is an ETL(Extract-Transform-Load) task.

    I would like running sql to automate it.

     https://b23.tv/3n30jrt

     //select  rowid old_rowid,colIndex[1:19] from consolidateSheet;
create temp table aa as 
select rowid old_rowid,colIndex[1:19] from consolidateSheet where f04!='Students';
 cli_one_dim_with_zero~temp.aa~4;
create temp table cc as 
with bb as (
select *,(cast(regexp2('\d+',属性) as int)-1)/2 grp from aaunion order by old_rowid)
select *,regreplace('(\d+)\/(\d+)\/(\d+)','20$3-$1-$2',group_concat(数量,'</td><td>')) Date_Result from bb group by old_rowid,grp;
cli_no_header;
select f03,f04,f02,Date_Result from cc;

     You can find other ways to acheive it too.

Resources