Read text file(variable columns) in OIC

Summary

Facing error(Error while reading native data) when reading text file with variable columns in OIC using stage read

Content

Hello,

I have a requirement where I have to modify certain values in BAI2 file from bank and import in Oracle.

BAI2 text file can have different number columns in each row. For example below are three rows of BAI2 file

01,042000314,XYZZ,190201,0244,1,80,1,2/                                        
02,TEXTILE,042100230,1,190130,2359,USD,2/                                    
03,00073972185,USD,010,+0000000000000000,,,015,+0000000000000000,,/ 

Step 1 : Downloaded the file to ICS

Step2: I am trying to read the file(to modify) using Invoke -> Read file option. for Schema I created a sample with maximum number of columns that can come in BAI2 file. All the columns except 1st column were made optional.