Consolidating recursive modules

yatin.ajbani · 2024-05-07T06:57:08+00:00

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…

yatin.ajbani

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

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…