AnsweredAssumed Answered

The document cache lookup in Map is printing out same value for every lookup.

Question asked by anwesh_elisetty900421 on Aug 20, 2018
Latest reply on Aug 22, 2018 by anwesh_elisetty900421

 

 

 

 

1) In Branch 3: I have an HTTP Client connector which I write to a cache (JSON).
2) In branch 4: input is CSV file with employee details

Request:
EMPID|COMPETENCY_ID|COMPETENCY_NAME|DESCRIPTION|COMP_RATING_LEVEL|55_ID
1094814|compt000000000020832|GS: SAN McData Installation Upgrade|Ability to install and upgrade McData SAN hardware.|5.0|compt000000000008910
1094814|compt000000000020832|GS: SAN McData Installation1 Upgrade|Ability to install and upgrade McData SAN hardware.|4.0|compt000000000008910
1094814|compt000000000020832|GS: SAN McData Installation2 Upgrade|Ability to install and upgrade McData SAN hardware.|3.0|compt000000000008910
1010783123|compt000000000011201|GS: Data Domain Installatio Upgrade|Ability to install and upgrade Data Domain hardware.|5.0|compt000000000008768
Shashank01|compt000000000020832|GS: SAN McData Installation2 Upgrade|Ability to install and upgrade McData SAN hardware.|3.0|compt000000000008910
kishan|compt000000000020832|GS: SAN McData Installation2 Upgrade|Ability to install and upgrade McData SAN hardware.|3.0|compt000000000008910
1010783124|compt000000000011201|GS: Data Domain Installatio Upgrade|Ability to install and upgrade Data Domain hardware.|5.0|compt00000000000876

 

3) Unique map to get Unique EMPID's.

Output:
EMPID|COMPETENCY_ID|COMPETENCY_NAME|DESCRIPTION|COMP_RATING_LEVEL|55_ID
1094814|||||
1010783123|||||
Shashank01|||||
kishan|||||
1010783124|||||

New Map: using document cache lookup to see EMPID is present in Active engineer list cache.

 

 

 

In output it needs to print 1094814, shashank01 and Kishan but it is printing only 1094814.

Outcomes