Good day to all!
Say you have a list with 18 fields. These fields contain values that are associated by name in six groups of three. Example:
Project 1 Task 1 Subtask 1 Project 2 Task 2 Subtask 2 Project 3 Task3......
The goal is to query any given row for the value of a defined variable and return which field it was found in.
Example:
Project 1 Task 1 Subtask 1 Project 2 Task 2 Subtask 2 Project 3 Task3......
One Green Cotton Two Blue Wool Three Red
If we query the current item for a variable with value "Two," then we know that it came from Project 2. Ultimately we would use this as a "key" of sorts to then bring the associated Task and Subtask with it.
Any thoughts on this would be appreciated. Thanks in advance to the community.