Consolidating recursive modules

yatin.ajbani

Hi

I have 2 Lists and 3 modules as shown below. I want to build module 4 (details below) in the most efficient manner. Seeking ideas. Thanks in advance

List: Employee
	ssL0Employee	ssL1Employee	ssL2Employee	ssL3Employee
Employee 1	Y
Employee 2	Y
Employee 3	Y
Employee 4	Y
Employee 5		Y
Employee 6		Y
Employee 7		Y
Employee 8			Y
Employee 9			Y
Employee 10				Y
Employee 11				Y

List: Employee Type
	ssL0Employee Type	ssL1Employee Type	ssL2Employee Type	ssL3Employee Type
Full Time Employee	Y
Part Time Employee	Y
Remote Support Staff		Y
Specialist		Y
Employee Manager		Y
National Manager Sales			Y
National Manager Performance			Y
Regional Senior Director				Y

Module 1 (Dimenionalized by ssL0Employee and ssL1Employee Type) with 2 line items of L1EmpRelation and L1EmpType
	RemoteSupportStaff		Specialist		Employee Manager
	L1EmpRelation	L1EmpType	L1EmpRelation	L1EmpType	L1EmpRelation	L1EmpType
Employee 1	Employee 5	Remote Support Staff	Employee 6	Specialist
Employee 2	Employee 5	Remote Support Staff			Employee 7	Employee Manager
Employee 3			Employee 6	Specialist	Employee 7	Employee Manager
Employee 4					Employee 7	Employee Manager

Module 2 (Dimenionalized by ssL1Employee and ssL2Employee Type) with 2 line items of L2EmpRelation and L2EmpType
	National Manager Sales		National Manager Performance
	L2EmpRelation	L2EmpType	L2EmpRelation	L2EmpType
Employee 5	Employee 8	National Manager Sales
Employee 6	Employee 8	National Manager Sales	Employee 9	National Manager Performance
Employee 7			Employee 9	National Manager Performance

Module 3 (Dimenionalized by ssL2Employee and ssL3Employee Type) with 2 line items of L3EmpRelation and L3EmpType
	Regional Senior Director
	L3EmpRelation		L3EmpType
Employee 8	Employee 10		Regional Senior Director
Employee 9	Employee 10		Regional Senior Director

	Expected Output
	Module 4 (Dimensionalized by ssL0Employee) with line items Mapped Emp 1, Mapped Emp 2, Mapped Emp 3, Mapped Emp 4, Mapped Emp 5, Mapped Emp 6, Mapped Role 1, Mapped Role 2, Mapped Role 3, Mapped Role 4, Mapped Role 5, Mapped Role 6
UniqueID		Mapped Emp 1	Mapped Role1	Mapped Emp 2	Mapped Role 2	Mapped Emp 3	Mapped Role 3	Mapped Emp 4	Mapped Role 4	Mapped Emp 5	Mapped Role 5	Mapped Emp 6	Mapped Role 6
1	Employee 1	Employee 5	Remote Support Staff	Employee 6	Specialist		Employee Manager	Employee 8	National Manager Sales	Employee 9	National Manager Performance	Employee 10	Regional Senior Director
2	Employee 2	Employee 5	Remote Support Staff		Specialist	Employee 7	Employee Manager	Employee 8	National Manager Sales	Employee 9	National Manager Performance	Employee 10	Regional Senior Director
3	Employee 3		Remote Support Staff	Employee 6	Specialist	Employee 7	Employee Manager	Employee 8	National Manager Sales	Employee 9	National Manager Performance	Employee 10	Regional Senior Director
4	Employee 4		Remote Support Staff		Specialist	Employee 7	Employee Manager		National Manager Sales	Employee 9	National Manager Performance	Employee 10	Regional Senior Director

TimPeterson

Hello. The solution to your problem is to use a list lookup module for the different employee types.

Using this module it is possible to use lookups to pull in the data from the different modules.

Please let me know if this works for you, or if you need additional help. The lookups for module 1 only require a lookup against the relevant employee type. The lookups against modules 2 and 3 require an additional lookup against a prior Mapped Emp# and an isnotblank check to check multiple potential Mapped Emps.

yatin.ajbani

Thanks @TimPeterson . This will work. However, the EmployeeType list is dynamic, the values in it can move from SSL1 to SSL2. Do you think there is a way to solve this without hardcoding the values of EmployeeType as line items? We can also have the output as below

	MappedEmployee	MappedEmployeeType
Employee 1	Employee 5	Remote Support Staff
Employee 1	Employee 6	Specialist
Employee 1	Employee 8	National Manager Sales
Employee 1	Employee 9	National Manager Performance
Employee 1	Employee 10	Regional Senior Director
Employee 2	Employee 5	Remote Support Staff
Employee 2	Employee 7	Employee Manager
Employee 2	Employee 8	National Manager Sales
Employee 2	Employee 9	National Manager Performance
Employee 2	Employee 10	Regional Senior Director
Employee 3	Employee 6	Specialist
Employee 3	Employee 7	Employee Manager
Employee 3	Employee 8	National Manager Sales
Employee 3	Employee 9	National Manager Performance
Employee 3	Employee 10	Regional Senior Director
Employee 4	Employee 7	Employee Manager
Employee 4	Employee 9	National Manager Performance
Employee 4	Employee 10	Regional Senior Director

TimPeterson

I think it's possible. But I would need more definitive rules around how the employees and employee types interact. Example, are there situations with more than one employee assigned to an employee type?

yatin.ajbani

Hi @TimPeterson

Yes there could situations where more than 1 employee have same employee type but not the other way around where an employee can have more than 1 employee type.

Thanks