Replicating Microsoft Access 'HAVING' statement in datameer 6.4

Follow

Patrick

• April 24, 2018 18:02

Hello,

 

I am trying to replicate a Access Query that contains a HAVING statement. This query requires a join between two tables which I have replicated on datameer on Sheet_A, then I have created Sheet_B where I groupby my required columns sourcing Sheet_A. 

I am confused on where to implement the HAVING statement, either on Sheet_A or Sheet_B, the statement is as follows;

HAVING (((IIf([Sheet_A]![ID] Is Null,[Sheet_A4]![ID],[Sheet_A]![ID])) Is Not Null));

 

Do I use Advanced Filters on Sheet_A or Sheet_B?

 

Thanks

0

• 

  Joel Stewart

  • April 24, 2018 21:09

  Can you share a bit more about the goal that you're trying to accomplish? There is not a direct equivalent to the HAVING clause within Datameer since it uses a different paradigm. 

  Speaking generally, I'd start by bringing in both tables through Data Links or Import Jobs. Then you could pre-filter the results before joining in Datameer or use a filter on the join results sheet to remove the values that do not meet your desired criteria. 

  0

  Comment actions Permalink

Please sign in to leave a comment.