BlockUntilDone Tool doenst work like it should

df

Hello i have some Problems with the "Block Until Done" Tool.

My test:

1) i created an Table in mysql with column "date" and "KPI"

2) Now i wanted to update the last to days.

i SHOULD be: search for Min Date in the Groupfunction. And Insert Into everything (again) in the table where date is smaler then min_date

After that: append the columns i wanted to updated in the table

But the Block 2 is done first.

What i am doning wrong?

Cheers,
David

reply_mueller

Hello David,

this approach seems still a little bit difficult in my eyes. You could use something like this, but I would advise you not to use a surrogate key but the date as a primary key, since it seems, that all dates are unique in your database design.

This would boil down the approach drastically to a simple setup like this:

 It is important to set the Output Options to Update; Insert if New, in order to produce the desired behaviour.

If this workflow relies fully on user entered dates and KPIs, you could consider making an Analytic App out of it, by parametrizing the text input node, to provide a better UX.

I hope this helped.

Johannes

(Blue Reply)