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....