![]() ![]() Would ingesting this data with java inside of kettle be a better method?Īny help with this would be much appreciated. pentaho-data-integration I need to output a different CSV file every 100 rows. I'm unable to read any records, and I'm not sure if this is the correct approach. The data provider has also generated a column header line at the beginning of the file, listing field data types. Record Separator (RS) : STX (ASCII character 2) + “n”Īny record starting with a “#” and ending with the RS should be treated as a comment by the ingester and ignored. The following are the delimiters forįield Separator (FS): SOH (ASCII character 1) Here's a description of the file structure:Įach file in the feed is in plain text format, separated into columns and rows. I can see all the data when I preview the content of the file in Kettle, but no records load when I try to preview rows on the "Content" tab.Īccording to my research, Kettle should understand my field separator when typed as "$" which in my case is "$". ![]() I'm trying to use Spoon / Kettle to upload a plain text file that is separated by ASCII characters. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |