Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can we convert the ITF (Interchange Text Format) to regular text in Qlik Replicate
Are you talking about " The format ITF (Interchange Text Format) is a SAPscript format for storing and displaying SAPscript texts. This format consists of all characters that can be displayed on the screen (system character set) Before outputting a text, the SAPscript composer must first convert the ITF format to OTF format (Output Text Format), using the layout definitions of the allocated style and form." ???
Seems like someone ingested too much 'cool-aid'
Replicate does NOT know how to do this 'out of the box'. If the input column is available a simple text, then maybe a User Defined Transformation function can be created, using lots of SAP hard core programming skills to do this.
Hein
Hello @AKV0524 ,
I'd like to add a more common explanation besides @Heinvandenheuvel expert point of view: The Replicate File endpoint can be used either as source or as a target. For your scenario, the text format output on the target side is fine. When File is used as a source, the File endpoint requires the source files to be in delimited text file format includes:
1- CSV: Comma Separated Values
2- TSV: Tab Separated Values
3- Any other format if it's available by an ODBC Driver. For example, "Microsoft Access Text Driver" can be used to access the Fixed Format File as source.
Detailed information can be found in the File Endpoint General overview.
Hope this helps.
Regards,
John.