One Star

Variabel on first if output null

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?
1 REPLY
One Star

Re: Variabel on first if output null

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