When using the FileAdapter, customers can use a % as a wildcard in the FORCE_FILENAME_PATTERN setting in the CFG file. The FileAdapter will then read every file in the folder that matches that wildcarded string as one virtual table.
Customers often have a scenario where an external process copies files in to the FileAdapters' data folder, and the files have a timestamp appended to the filename. For example, FORCE_FILENAME_PATTERN=SALES_% will match all files that are dropped in monthly:
However, sometimes a simple wildcard is not enough. Let's say, for example, that along with the files above, each SALES file also has a corresponding descriptive file of the same name, but with a .sum extension. You'd like to exclude those files from virtual table.
SAP HANA Database, Smart Data Access, Smart Data Integration, File Adapter, regular expressions, virtual table, case sensitive, SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.