Variabel on first if output null

Anonymous — Tue, 20 Aug 2013 12:54:11 GMT

Hey @ll,
i try to check the sum of all DB-actions against the number of rows in my input file. There for i use the if-output at the last db-action. But in the first round of my process (i work with a file list), one count of db-actions is everytime "Null".
My if looks like this :

null!=globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED") &&
 null!=globalMap.get("tMysqlOutput_1_NB_LINE_UPDATED") && 
null!=globalMap.get("tMysqlOutput_2_NB_LINE_INSERTED") && 
null!=globalMap.get("tMysqlOutput_2_NB_LINE_UPDATED") && 
null!=globalMap.get("tMysqlOutput_3_NB_LINE_INSERTED") && 
null!=globalMap.get("tMysqlOutput_3_NB_LINE_UPDATED") && 
((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_INSERTED"))+
((Integer)globalMap.get("tMysqlOutput_1_NB_LINE_UPDATED"))+
((Integer)globalMap.get("tMysqlOutput_2_NB_LINE_INSERTED"))+
((Integer)globalMap.get("tMysqlOutput_2_NB_LINE_UPDATED"))+
((Integer)globalMap.get("tMysqlOutput_3_NB_LINE_INSERTED"))+
((Integer)globalMap.get("tMysqlOutput_3_NB_LINE_UPDATED"))!=
((Integer)globalMap.get("tFileRowCount_1_COUNT"))-((Integer)globalMap.get("tFilterRow_4_NB_LINE_REJECT"))

Is there another posibility?

Re: Variabel on first if output null

Anonymous — Wed, 21 Aug 2013 06:50:10 GMT

Try to use your input file component name itself, eg: if it is a excel files then you can find the no of rows using following expression
((Integer)globalMap.get("tFileExcelSheetInput_1_NB_LINE"))
and Db record count you have to use tFlowmeter

topic Variabel on first if output null in Talend Studio

Variabel on first if output null

Re: Variabel on first if output null