Forum Discussion
Solved
Input 1 to 7 SKU numbers to return groups of rows.
My actual document has 300 cases of product listed in rows, I trimmed it down to 20 cases of product for this example and replaced the names for confidentiality. I want to be able to input these t...
select * from Sheet1;
create temp table aa as
select colIdxf[0:1]{udf_fillna_m(%s,"a%s") %s},f03,f04,f05 from Sheet1;
create temp table bb as
select f01 from aa where regexp('9800006353|9800006357|9800006356',cast(f03 as text)) group by f01 having(count(f03)=3);
create temp table cc as
select * from bb inner join aa using(f01);
//select * from cc;
cli_merge_row~cc~2;