How to Load a CSV file based upon the metadata and different structure in the File.

[Anonymous]

I have 138000 files I need to load with the following structure. The first column I have added as an explanation of what are the contents of reach line.

Line 1 Drives values to be loaded from Lines of Atom 1 to Atom 19 (Child Table)

Line 2: Its data needs to go into Parent Table

Frequencies need to into Parent Table

Last 2 lines need to go into  Parent and Child Tables.

Any idea how to do this?

Explanation

To see the whole post, download it here

[vapukov]

as variant, split job for 3 step

1) read file (no header) - read only 1 line, store number to variable

2) read file, skip 1 line, read number of lines stored in variable on step 1 (LIMIT)

3) read file, skip 1+ variable lines (header == 1+ variable), limit = 2

[Anonymous]

Do I have to write code for it or can it be done by gui?

[vapukov]

if all files have the same structure  (number of columns)

all possible to do with standard components:

tFileInputDelimited

tFlowToIterate

tMap

etc

if not - it more complicated

[Anonymous]

All files are the same. Can you give me a fwe more details on these steps please? It will help me shorten my learning curve.

Thanks!