Returning a list member's code based off a unique property?

NumberOneAnafan

Hi all! I have a module with a line item for "SKU" (text format), that lines up with a "SKU" property (also text format) within a specific list. In that initial module, I want to return the corresponding code for the list member with that matching SKU property.

Example:

List: Item Number

List Member Code: 123

List Property: "Item Number.SKU" = XYZ

In my module, I have a line item "SKU" returning text "XYZ" - how can I then get another line item to return List Member Code "123" based off that? Note that the list property "SKU" is unique to each list member

devrathahuja

Hi @NumberOneAnafan ,
You can use firstnonblank to reverse the mapping & then use lookup to pull the value.

Refer to the below screenshots for reference-

This is my source module where we have the code & list property (Similar to you having SKU)

Then create a SYS module with this list that will look like this-

Pull the code & mapping to the line items. Note that the mapping reversed line item is dimensioned by the SKU list and not the original list. So here we bring the code against each SKU instead of the original list member which will act as a bridge for our final step.

In the final module then you can use a lookup to fetch this value-

So here, when we have a line item with the mapping that we also have as a property in another list, we can fetch the code based on that.

Hope this helps! :)