The Definitive Guide to Data Quality
Solved! Go to Solution.
I think there is a deeper problem i do not see, perhaps i cannot use this globals overall??
But i thought globals mean overall
Re your globalMap problem: you say that you've used tSetGlobalVar so to reference the stored values you should be using the Key name from that component e.g. (Date)globalMap.get("LastDateTime"). globalMap.get tries to find a variable with the name that's in the brackets. Note that you can also use auto-complete (Ctrl+Space) to obtain the correct reference to the variables created with tSetGlobalVar (although you might need to change the data type reference in the preceding brackets.
What you are doing in tSetGlobalVar is creating a globalMap variable with e.g. the name set to the value of row5.dirty_datetime_last and the value set to the String "+row5.dirty_datetime_last+". No wonder you can't access them!
It should look like the following screenprint and be accessed using (Date)globalMap.get("row5.dirty_datetime_last").
Note that if you want to store a lot of values from a row into the globalMap, it's easier to just use tFlowToIterate with "Use the default (key,value) in global variables" checked as this will do exactly what I've shown in the screenprint for all the columns in the flow.
You left out the row5. on the right-hand (value) side. Check my screenprint again
how could i manage it to use the results of both subjobs?
I noticed, that both subjobs are executed quasi parallel, but if i want to compare both results (one or more rows), these results have to be there to same time, aren`t they?
Usually i use a tmap component with two inputs and one output.
You've put two copies of the tSetGlobalVar screenshot instead of tMap.
But, yes, OnComponentOK is executed before OnSubjobOK so the subjob from tWaitForSqlData to tFileOutputExcel is executed before the tSetGlobalVar subjob in your design. If you want tSetGlobalVar executed first then instead of the OnComponentOK from tMysqlConnection to tWaitForSqlData you should have an OnSubjobOK from tMysqlInput_3 to tWaitForSqlData.
But I'm not exactly clear on what you're trying to do/what order you want things to happen...