LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: the1don

Can I please get assistance on how to have Lavastorm
1) read 2 inputs (query1 and BRD)
2) compare the 2 inputs for differences
3) if the number of differences is 10 or more, or if today is Friday continue processing otherwise stop and do nothing.

The goal is to only continue processing if the number of differences is 10 or more or if today is Friday

The way I am trying to do it is below but I can't get the whole logic

Thank you
Don

1) I have 2 inputs (in my case 1)db query and 2) a brd).
2) I use an xref node and on the left and right pins emit "0" as match - the 0 indicates 0 matches
3) I CAT the left pin (which are 6 rows of 0) and the right pin (which is 6 rows of 0)
4) I Ag the output of the CAT node to get the total number of differences (ex rows = count()) grouping by match
5) I Filter the data
6) This is where I stuck.

Any suggestions on how I am doing this or how I would use a filter node to tell the process to continue or stop would be appreciated.

Thank you
Don

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

You can find the parts of the answer to your questions that you need in other threads.

Here is one that discusses a couple ways to either make nodes not run or not do anything depending on some values. http://community.lavastorm.com/threa...=7384#post7384

This thread is about dealing with zero records when you are counting records. http://community.lavastorm.com/threa...=count+records

This thread discusses how to retrieve the day of the week. http://community.lavastorm.com/threa...highlight=week

I hope you figure it out.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: the1don

Thanks for the reply. Here is how I finally got it to run. Testing all the scenarios now. Plus I will look at the references you have here to see how else I could do it.

Steps 1-4 are still the same as above.
At Step 5 instead of using a filter node I used a Meta Check node and set the TerminusAction = "NeitherOutputNorClock" The SuccessAction to "BothOutputAndClock" and the MinimumRecordCount to 1. I had the Output Clock tied into the Input clock on the next node to run if successful.

Thus when a row was returned that met the criteria in the AG node. The Meta Check would return with a 1 which met the minimum for a success and run the next step(s) in the process.

Testing it now but so far so good.