AnsweredAssumed Answered

Flat file Profile - with different number of columns in different rows

Question asked by lawson_it_support275393 on Sep 22, 2017
Latest reply on Nov 16, 2017 by pthaware@deloitte.com

Boomi Team -

 

For a flat file, does number of columns need to be absolutely equal in all the rows of a file.

Lets say i have file as below (pipe delimited)

abcd|efgh|1234                                                               (first row has 3 columns)

xyz|apple|banana|car||||||||||petrol||||||zebra                     (this has more than 3 columns)
1|2|3                                                                                (this has 3 columns)

Is it possible to create flat file profile based on the above structure. The number of columns in each row are different.

I believe it is not possible....

Outcomes