segmented CSV into table

Hi there,

i just started working with knime and love it.

XML was kind of easy and straight forward, but csv really paused my progress for the moment, can you please give me a hint how to go on?

i have csv files that segment the data in 3 segments:

000001.csv

1;Adress1;Adress2

2;Position1;InvoiceNb.XXX

2;Position2;InvoiceNb.XXY

2;Position3;InvoiceNb.XXZ

3;PaymentAdviceNumber887654321;Name_Vendor VVV

1;Adress13;Adress14

2;Position1;InvoiceNb.AAA

2;Position2;InvoiceNb.AAB

2;Position3;InvoiceNb.AAC

3;PaymentAdviceNumber12345678 ;Name_Vendor VVV

i would like to get a table that combines the Datasets to look like that:

| PaymentAdviceNumber | Name Vendor | Adress1 | Adress2 | PositionNb | PositionInvoiceNb |
| 887654321           | VVV         | 1       | 2       | 1          | XXX               |
| 887654321           | VVV         | 1       | 2       | 2          | XXY               |
| 887654321           | VVV         | 1       | 2       | 3          | XXZ               |
| 12345678            | VEV         | 13      | 14      | 1          | AAA               |
| 12345678            | VEV         | 13      | 14      | 2          | AAB               |

all ideas appreciated, thank you!