SSIS Ragged Equivalent in Azure Data factory

Question

Hi Guys ,

We have data in text which is in below format
4500078454 00010 MK10 20200730 0030-4 xyzz xyzz xyz xy 1/8 xyz --ST/STL- 0001 20160427 20160404 h331 tramp - 1120 eeeee LANE xxxx INTERNATIONAL CORP 112 xxx LANE 111-1111 rerddcx bs vt bst 4420114400 29.000 0.000 29.000 km 2 7318.19.0000 trr33 m 0 0000000107 bin X X bn 0000000 bus xxx xxx xxx CORPORATION xx xxx 12111 xxss fr 55555-222 sssss km vt bSTST 444-555-4321 mmm.mmm@Mmm .com myhouse 0000

In SSIS we use ragged; but how can we extract above data as separate columns in ADF?

Regards,
Navin

Answer 1

Are you referring to "fixed-width" file handling? https://kromerbigdata.com/2019/08/20/process-fixed-length-text-files-with-adf-mapping-data-flows/