Get row number using the map function based on 2 keys

Questions & Answers
, ,
1

I am trying to use the map function to retrieve a row number in a google sheet based on 2 keys: Transaction ID and Line number.

I am guessing I cannot have 2 keys in the same map function. This is what I have but it is not filtering the second key. Any ideas?

{{first(map(101.array; “ROW_NUMBER”; 6; 34.Id; 13; 116.LineNum))}}

Capture1
Capture1471×572 22.7 KB

Capture2
Capture3
Capture4

2

Hi @Shawn

Unfortunately, the map function can only handle a single filtering condition. For a simpler solution, try iterating through the data and applying filters afterward.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

You are already using an iterator/aggregator combo.

Just insert a filter in-between those two modules to filter out items that you don’t need.

2 Likes