Mapping data with wildcard char values in one of the fields

[#1]

Hi

How does one map data ( file attached )when field values have a wildcard char.

The task /Account/ActivityID values from the Mapping Matrix have to be mapped  to the fields in Data File

The data file has to be loaded and the records have to be checked against the fields given in the Maapping Matrix.

the Data file.Country = Mapping Matrix.Country1  and  DataFile.ServiceTitle= MappingMatrix.Service

[#2]

Hi rajashree,

Sorry if i'm wrong. Try the script like this

Mapping:

LOAD Country,

     Service,

     task,

     account,

     [activity Id]

FROM Mapping_matrix;

Data: inner Keep (Mapping)

LOAD Country,

     Service,

     ServiceTitle

FROM Data_file;

DROP Table Mapping;

Give the same field names in Mapping and data tables like country and service. Using inner keep we can get the data if country and service are equal in both tables. Drop the first table if you dont need it.