topic Re: How to enter a conditional "Where" clause in the below Script? in Discussions

How to enter a conditional "Where" clause in the below Script?

dfusco923 — Fri, 09 Jun 2023 22:05:26 GMT

I would like to make two Tabulate tables instead of one Tabulate table. I'd like one Tabulate table for :Prog = "A" and one for :Prog = "B". The script below gives me one Tabulate table with both Programs "A" and "B" in the Tabulate table. I think if I was to break this up into two lines of script; one line being . . . where :Prog = "A" and the other line of identical script except for . . . where :Prog = "B" would do the trick I just don't know where or how to insert the "where" clause.

Tabulate( Add Table( Row Table( Grouping Columns( :Prog, :Matl_Desc ) ) ) );

Re: How to enter a conditional "Where" clause in the below Script?

txnelson — Sun, 07 Feb 2021 03:10:15 GMT

Tabulate( Add Table( Row Table( Grouping Columns( :Prog, :Matl_Desc ) ) ),
where(:Prog == "A") );

You may want to look into using the Page feature in Tabulate, it will create a separate table for each level of Prog

Re: How to enter a conditional "Where" clause in the below Script?

dfusco923 — Wed, 10 Feb 2021 14:42:18 GMT

Thanks for the help.