How to look up first instance of a numbered list

JZCG
JZCG
in Modeling

I have a module (Module A) that applies to a list.

Job Title

Salary

Bob

John

Katie

I have a different module (Module B) that uses a numbered list. The display names of the numbered list matches the names in the regular list.

How do I look up the first instance of the "Job Title" in Module B so Module A shows Bob's Job Title is A?

Job Title

Salary

Bob (#1)

A

John (#2)

B

Katie (#3)

C

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @JZCG

    In your numbered list, what format is the Display Name property? If it is TEXT, change it to List formatted to be the Employee Flat list (what the first module is dimensionalized by). Then, in Module A, your formula would be ModuleB.Job Title[FirstNonBlank:Numbered List.Display Name].

    Rob

Categories