2020-06-30-9-39-29.pngHi All,
I have pretty much a situation here for txt flat file processing into HANA. Txt flat files are being dumbed at share folder with the numeric name for example '123344.txt'. All these types of files contain some half structured Data( have few fields and data along with that). I need to extract data from the unstructured format and load it into HANA in a structured format. Later need to make this process totally automated once the process of data extraction of structured information from files in place.
Attaching sample data txt file for your reference. Highlighted one shows probably fields that could be fields of HANA tables. There are more fields in the same file and others too, for privacy purposes can't attach complete file here. Please let me know your thoughts and suggestions as soon as possible.
It will be a great help and appreciated.
Thank You
Sunil Sharma