Consolidating recursive modules

Options

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

Answers

  • TimPeterson
    edited May 8
    Options

    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.

  • 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

  • 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?