ADaM Define WhereClauses sheet missing in P21 update

Trevor

on May 17, 2022

P21

Hi Chris, The new enhanced…

Hi Chris,

The new enhanced Excel template we adopted starting in Community 4.0 no longer includes a WhereClauses worksheet. Many users complained that this worksheet was cumbersome and so we simplified the way Where Clauses are defined by allowing users to describe them directly on the ValueLevel worksheet in column D--titled "Where Clause".

Values you enter here can be in the form of:

• Simple where clauses, e.g.,: DATESTCD EQ DISPAMT
• Compound where clauses, e.g.: LBTESTCD EQ BILI and LBCAT EQ CHEMISTRY and LBSPEC EQ BLOOD

There is no longer a need to define where clauses on another worksheet and then link them together using a unique identifier.

I hope this helps.

Trevor