If an SAP R/3 dataflow produces 1 datatransport with multiple types of records delimited by a special character and has header records for each of those types of records, is there any way DI can produce multiple relational tables based on the header information?
File looks like:
Table_name ; Field 1 ; Field 2 ; Field 3 ; Field 4 ; Field 5
tbl_abc ; Data1 ; Data2 ; Data3
tbl_abc ; 123 ; 456 ; 789
tbl_abc ; 234 ; 345 ; 456
tbl_xyz ; Data4 ; Data5 ; Data6 ; Data7 ; Data8
tbl_xyz ; 134 ; 345 ; 457 ; 567 ; 346
tbl_xyz ; 243 ; 436 ; 365 ; 457 ; 566
should produce 2 tables, tbl_abc and tbl_xyz. tbl_abc has 3 fields and Data1 , Data2, Data3 are the column names. tbl_xyz has 5 fields and Data4, Data5 , Data6 , Data7 , Data8 are those column names.
I don’t want to manually write what the output column names are, I want DI to dynamically figure that out, as it can change.
Thanks,
Nile
Nile 
(BOB member since 2004-02-12)