Using Wildcards

Prerequisites

Your data is stored in multiple sets of files.

Context

In case your data is stored in multiple sets of files, you can specify a wildcard (*) for the name of your file.

A wildcard can be used every time the files for several import runs come from different files, with the file name being different is some characters only.

Procedure


  1. From the list of steps, choose Specify Files.

  2. Switch to change mode.

  3. Position the cursor on Values for Wildcards.

  4. Choose Create Entry. A dialog box appears.

  5. Enter the value and description of the wildcard.

  6. Choose Continue.

Results

The values for the wildcards have been created.

Example

In each import run, the data for one company code is to be imported.

Source file:

Filecocd1

Filecocd2

Filecocd3

Specification of legacy data:

File name:

Filecocd*

Read data:

Filecocd*.lsmw.read

Converted data:

Filecocd*.lsmw.conv

Values for wildcard

1, 2, 3

When reading and converting the data, the wildcard value (1, 2, or 3) has to be entered each. After this, the corresponding source file is read and a "company code-specific" file of the data read is generated.