Função de Ánalise Qlikview


SUB Info(_LoadTable)

	REM :::::::::::::::::::::::::::::::::::::::::::::
	:: Log de Carga Sept by Step
	:: Autor: William M.
	:: Parametros:
	::    _LoadTable: Nome da Tabela que está
	::sendo carregada
	::::::::::::::::::::::::::::::::::::::::::::::::;
	
	LET vTimeStep = vTime;
	
	LET vTable = TableName(NoOfTables()-1);
	LET vStep  = if(IsNull(NoOfRows('$Info')),1,(vStep + 1));
	LET vLines = Num(NoOfRows(TableName(NoOfTables()-1)),'#.##0');
	LET vTime  = Time(Now()-vStart);	
	
	LET vTimeStep = if(vStep > 1,Time(vTime - vTimeStep));
	
	_LoadTable = _LoadTable;	
		
	TRACE º TABLE:$(vTable) LINES:$(vLines) TIME:$(vTime) TIME_STEP:$(vTimeStep);
	TRACE ;
	
	REM:: Tabela que armazena as informções para verificar duplicidade;
	[$Info]:
	LOAD *  Inline [
		Step, Time, Table, Load Table, Lines, Time Step 
		$(vStep), $(vTime), $(vTable), $(_LoadTable), $(vLines), $(vTimeStep)
	];
	
	TRACE ;

END SUB