The Definitive Guide to Data Quality
I know how to read the data since the 5 row using the tFileInputFullRow and setting the header to 5 and them using a tMap and a tExtractDelimitedFields to format the data.
But I need to read also the first part to join everything in the end to insert into my database.
My question is... how do I set on the tMap which row goes to one tool(tExtractDelimitedFields) and which row goes to another tool.
You could split your file into 3 parts using @ as the row delimiter using tFileInputFullRow. This would give you header, INSI and DATI. In your tmap you can put a condition to output1 for strings starting with INSI and output2 strings starting with DATI. You could then process each of these outputs with their correct schemas.