cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
dfusco923
Level III

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

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 ) ) ) );
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

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

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

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

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

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

Jim
dfusco923
Level III

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

Thanks for the help.