Jump to content

Find a value, twice or more, in a DT column


ORSO2001

Recommended Posts

Hi ORSO2001,
Use "Find DTI Column Value" Ladder function. This Ladder function finds a value in a column and writes the row index number into a data tag. If the function finds a matching row, the row number is stored in parameter E, Result. If no row is found, E contains -1. Function parameters:
    
        A    Data Table to Search
        B    Column to Search
        C    Value to Find
        D    Start Row for Search
        E    Number of Rows to Search

        F    Value Location: Row Index Number


Build your logic so that if a "Find DTI Column Value" call return a row index,  row index + 1 will be the "D  Start Row for Search" next value.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

This site uses cookies. By clicking I accept, you agree to their use.