Need to lookup Employee name basis the Employee order

Highlighted
Contributor

Need to lookup Employee name basis the Employee order

Hi,

 

Source module has All Employee list and basis their "Joining Date" (Line Item 1) "Rank" (Line Item 2) has been determined, in Target Module I have "Employee Order" (Line item) formatted as number.

 

Is their any way, basis the "Employee Order" in Target Module I can get the respective employee’s name from the source module in an another line item (formatted as Employee List)?

 

Thanks!

11 REPLIES 11
Highlighted
Certified Master Anaplanner

Re: Need to lookup Employee name basis the Employee order

Hi I @sharmagh 

What are the dimensions of the second module (containing the order numbers ?

 

Are there any other modules for the orders 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Need to lookup Employee name basis the Employee order

@einas.ibrahim 

1. It has Employee Category (list) in rows. 

2. No, these

are the two modules right now.

 

Highlighted
Certified Master Anaplanner

Re: Need to lookup Employee name basis the Employee order

@sharmagh 

If I understand you correctly you have the following 

  1. Employee category linked to Order # (is this a parent of the Employee List?) 
  2. Employee List
  3. Orders (linked to Employee Category)

and you want to include the employee name along with the order and category.

 

Let me ask you this; If you find a way to lookup the employee name, how would you know which order belongs to which employee?

Definitely something is missing. Please show your modules blueprint and/or the original data you are trying to implement into Anaplan (Excel file for example)

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Need to lookup Employee name basis the Employee order

@einas.ibrahim 

 

Though it is not the real module however, the structure is exactly same, kindly have a look:

Source Module:

sharmagh_1-1589704642987.png

 

 

Target Module:

sharmagh_0-1589704615686.png

 

all I want is to get he Employee Name in Target module from the source module basis their rank order.

 

Thanks!

Highlighted
Certified Master Anaplanner

Re: Need to lookup Employee name basis the Employee order

Hey @sharmagh 
Thanks for the info.

As I asked before, how will you match the employee name to the data in the "temp emp mod" module?
For example, what would be the employee name for the intersection of Jan 19 and Cat A? is it going to be Emp A because Emp A has a rank 1 and the combination of Jan 19 and Cat A has a rank 1 as well?

Please explain the business logic because I don't see the relationship between Cat, Emp, and Rank. 

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Need to lookup Employee name basis the Employee order

As i said, this is not the actual scenario, due to complaince issue i can't share the it,  so can't  explain you the buisness logic however, yes the employee name in target module should come basis the rank order. 

 

You can ignore the Category and basis rank order try to get the employee name.

Highlighted
Certified Master Anaplanner

Re: Need to lookup Employee name basis the Employee order

@sharmagh 

 

I don't believe I can provide a useful answer in this situation. I fail to fully understand the ask. 
You don't have to provide the actual business logic in your questions, but a complete logic is needed to help others help you.

One general technical issue that may help you is the following:
To get the "Name" of an item in a list you can use the formula NAME(ITEM(List Name))

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Master Anaplanner/Community Boss

Re: Need to lookup Employee name basis the Employee order

@sharmagh 

 

I wish I had a better answer.  

 

Even if you want us to ignore the category, are you saying that one rank will not be shared by multiple employees. If that is the case I would say

 

1. Generate a list based on Rank and Import Employee Names as an attribute

2. Use Finditem function in the Temp Emp Mod module to get the Rank from Lists.

3 Use Lookup to get the Employee name

 

But I am sure this is not the requirement because you are trying to Rank employees based on the start dates and then you want to check the rank based on the categories of the employees. There is a missing piece here

Highlighted
Contributor

Re: Need to lookup Employee name basis the Employee order

@Misbah 

 

1. Yes, One Employee one Rank

2. Basis the Joining date the rank will be calculated

3. In Second Module, the Rank Order is nothing but the PREVIOUS(Rank Order +1) formatted as number

4. Basis the Rank Order I need the respective Emp Name.

 

Let me know if i need to give more clarity