Creating flat file schema

, ,
1

I have the sample text file containg one record containg fullname and address.
But address is multiple i.e there are two addresses.I want these address to be appear as array. But Flat file schema is failing to parse adrresses.It only parse Fullname.

The content of flat file is

chintamanivasantjoshiHinganeKhurdPuneIndiaHinganeKhurdParramattaNSW.

2

Hi,

You should give Max repeat as unlimited for the record definition(address). Then save the schema and generate the DT. In DT, you can find the address as an array.