This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Find the nth occurrence in this row and lookup display name

Posted on 01-02-2022 07:49 PM
Steve_Chambers
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hi all, how would i write this expression:
If this row contains FALSE find the 1st occurrence of FALSE and copy that column display name into this text field

This expression will run in the action (add a new row to another table using values from this row) and will work against the table screenshot below, the columns that contain the TRUE, FALSE data are the columns I want to query

3X_6_0_60346b2dcc14cf24edd327c6004c76894743927a.png

The action will copy the data into a Failures table, you can see I have highlighted the desired results green

3X_b_3_b3026e7ba38c592abdea10052ee02e22ea2d2254.png

Iโ€™m thinking i need some blended version of INDEX, FILTER, and maybe LOOKUP to find the display name, but so far no luck, can anybody shove me in the right direction?

3X_8_c_8c99159e373f3f3a0c7c8388d7bbeeac14a1ad5a.png

Cheers,
Steve

0 4 247
Topic Labels
0 Likes
4 REPLIES 4
Top Labels in this Space