Hello friends, I'm having a little trouble trying to figure it out how to read the header of a file in a certain way and the rest of it in a different way. I have a file like this: ------------------------------------------------------------------------------------------------------------ *CRAP DATA : YYEAAP @ INSI LAT LONG ELEV TAV AMP REFHT WNDHT YYEAAP -3.1 10 4 5 6 -99 -88 @DATI SAAA TBBB TCCC RDDD 00001 5 10 15 20 00002 33 7 3 1 00003 34 8 4 31 00004 35 9 6 134 00005 36 10 7 15 ... ------------------------------------------------------------------------------------------------------------ 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? Thank you so much
Yesterday trying I did output them into two files and them started a new subjob opening the files. But which palette do I use to do that: One file has: 7LAG;2 The other file has: 11,8;22,7;99,9;27,7 12,3;74,8;76,3;99,9 ... I want them to be: 7LAG;2;11,8;22,7;99,9;27,7 7LAG;2;12,3;74,8;76,3;99,9 ...
Observation: the first file will always have only 1 line. Thank you so much!
