topic Re: Mapping load with more than one values in QlikView

Mapping load with more than one values

kkkumar82 — Mon, 22 Aug 2016 08:53:11 GMT

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

1213, 10, 200

1213, 10, 100

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

Re: Mapping load with more than one values

Gysbert_Wassenaar — Mon, 22 Aug 2016 08:55:45 GMT

Well, yes you could concatenate the values in the mapping table and then use the subfield function to create separate records again for each value in the list. But you should just use a join instead.

Re: Mapping load with more than one values

Anil_Babu_Samineni — Mon, 22 Aug 2016 09:06:03 GMT

Perhaps This

Dept:

LOAD * INLINE [

DeptID, Location

10, 200

10, 100

];

Join

Load * Inline [

EmployeeID, DeptID

1213, 10

];

Note: Real data, What you are facing?

Re: Mapping load with more than one values

kkkumar82 — Mon, 22 Aug 2016 09:20:44 GMT

Can you give the script ??

Re: Mapping load with more than one values

avinashelite — Mon, 22 Aug 2016 09:25:24 GMT

Try like this

Dept:

Load * Inline [

DeptID, Location

10, 200

10, 100

];

Mapping LOAD DeptID,

Concat(Location,',') as L

resident

Dept

group by

DeptID;

Emps:

Load *,

ApplyMap('T',DeptID) as Location;

Load * Inline [

EmployeeID, DeptID

1213, 10

];

Re: Mapping load with more than one values

sunny_talwar — Mon, 22 Aug 2016 09:42:18 GMT

I agree, one way could be to do a left join. But what exactly are you trying to do?

Re: Mapping load with more than one values

Gysbert_Wassenaar — Mon, 22 Aug 2016 10:50:32 GMT

Mapping Load
      DeptID,
     Concat(Location,'|') as List
Inline [
DeptID, Location
10,     200
10,     100
] Group by DeptID ;

Emps:
Load
     EmployeeID,
     subfield(ApplyMap('Dept',DeptID),'|') as Location
Inline [
EmployeeID, DeptID
1213, 10
];

Re: Mapping load with more than one values

florentina_doga — Mon, 22 Aug 2016 10:55:04 GMT

try this

final:

Load * Inline [

EmployeeID, DeptID

1213, 10

];

left join (final)

LOAD * INLINE [

DeptID, Location

10, 200

10, 100

];

Re: Mapping load with more than one values

kkkumar82 — Mon, 22 Aug 2016 11:06:16 GMT

Joining is the ultimate but we are insisted not to do a join till last try, as they are all transaction tables with huge data

Re: Mapping load with more than one values

sunny_talwar — Mon, 22 Aug 2016 11:11:43 GMT

With large data, it makes sense to not use joins. Use what Gysbert has proposed then.

Re: Mapping load with more than one values

kkkumar82 — Mon, 22 Aug 2016 11:13:40 GMT

Thanks alot Gysbert

Re: Mapping load with more than one values

kkkumar82 — Mon, 22 Aug 2016 11:14:20 GMT

Sure Talwar sab!