Mapping load with more than one values

[kkkumar82]

Hi All,

Dept:

Mapping  Load * Inline [

DeptID, Location

10,     200

10,     100

];

Emps:

Load *,

ApplyMap('Dept',DeptID) as Location;

Load * Inline [

EmployeeID, DeptID

1213, 10

];

When I reload I am getting a single record in Emps table with the first match ie 200, is there a way to get two records in the EMps table

as

1213, 10, 200

1213, 10, 100

I can get it with joins but the situation is different with real data.

[kkkumar82]

Thanks alot Gysbert

[kkkumar82]

Sure Talwar sab!