Global Variable returns zero records. I have to add a row count after all of the processing has been done. OATS_REPORT is the same file, and the data is being appended there. I don't know what I am doing wrong
If I understand your need, you want to know the number of lines in the file written by tFileOutputDelimited right after the tUnite. My advise is to use a tFlowMeter between tUnite and tFileOutputDelimited and to use its global variable NB_LINE.
Yes, you correctly understand what I want. By some lucky coincidence I was able to arrive to the configuration that was able to give me what I wanted. I don't fully understand why it works, but it does. Thank You
Hello, I used tFileRowcount -> tFixedFlowInput -> tLogRow to get the number of lines of a CSV File. I want to use this result for a max_number in a loop, but I don't know how to call it. In the TFixedFlowInput I have Column = linenumber, Value = ((Integer)globalMap.get("tFileRowCount_1_COUNT")). Is linenumber the global variable ? how do I call a global variable in a loop? Thank you very much ?
Hello You can set this global var ((Integer)globalMap.get("tFileRowCount_1_COUNT")) as max_number directly in a loop.eg: tFileRowCount | onsubjobok | tLoop--iterate-->do another transaction On tLoop, set 'to' field as: ((Integer)globalMap.get("tFileRowCount_1_COUNT")) Best regards
---------------------------------------------------------- Talend | Data Agility for Modern Business
Hai , I tried tfilerowcount (onsubjob ok)--> tfileinput delimited (main)--> tlogrow The job is running successfully but i dont see the output in tlogrow.Should there be some specifications made to get the output of count of file.
Hi While I use the tFileRowCount component to display the row count, its giving error. tFileRowCount (main)--> TLogRow Can anybody please explain how to get the total number of rows in a file using this component?
Hi friends how do i get the total number of rows in each column and what is the missing% in each column ..
what's your scenario? If you process with a column of file, you can use "Nb_LINE" to count the total number of records have been proceed. let me explain it more detail, if you are executing an operation "Insert data into tmysqloutput", and this option is set to Inserted, a global variable ((Integer)globalMap.get("tMysqlOutput_NB_LINE_INSERTED")), will counts the total number of records have been inserted. More information of requirement will be preferred. Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
I need to read the output file name from tfileoutputdelimited like path context.Output_Path+"/"+"MART_PTNT_PRFL_LAB_"+TalendDate.getDate("CCYYMMDDhhmmss")+".dat" .. After I need to create control file I need to create a control File which has file name of above and Count the no of lines Ex: filename.ctl Inside data should like below filename|xxx(count)