Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Add a subjob with these components tFixedFlowInput --> tFileOutputDelimited.
This subjob must be connected by an OnSubjobOk trigger to the subjob where the Excel file content is transfered to the output file.
For tFixedFlowInput, create a 2 fields schema (today and records) then complete the table with the following values:
For tFileOutputDelimited, reuse the same file name as for tFileOutputDelimited_1, select | as the field separator and tick the option "Appen" to write the next record at the end.
This should work.
Hello,
Since you need to get the current date before fetching the 1st record, you can use tjava and store current date in the required format in globalmap and then onsubjobok, the flow to read data from excel and loading to pipe delimited file will run and then again on subjobok, use tfixedflowinput which will have schema with 2 columns; in 1st column you will retrive the value from globalmap date variable and in 2nd column you will use nbline variable of input excel component and store the value in 2nd column of fixedfowinput.
Don't forget to give Kudos if you find the reply useful.
Regards,
BhavikaW
BhavikaW