Can an asterisk be used as wildcard to represent multiple .csv files for DATASET parameter of a MFD

Other

Product: Reporting Server

Release: 8206

Primary OS: Windows

Solution Date: 2020-08-06

Problem

Can an asterisk (*) be used as a wildcard to represent multiple .csv files for the DATASET parameter of a Master File?

Solution

Yes, an asterisk can be used for flat files. This applies to all flat file types including delimited.

A DATASET parameter or a FILEDEF for a flat-file can use an asterisk (*) as a wildcard to represent multiple files. To identify which file (of many) that a record comes from, you can add a field with an ALIAS of INSTANCE to the Master File. When used in a SELECT, TABLE, or MODIFY procedure, that field will have the name of the specific file.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.