Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Potential If Statement

Hello, 

 

I am Looking for a way to do the following

 

The results are highlighted in Yellow.

 

The Lookup Array would be the Well Name

Find a Match in the Origin Column and Destination Column

Pull the Last 2 Characters from the Matching Name

 

 

 

Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    Anonymous -

    This could do the trick as a column:

    Column = 
VAR searchOne =
    SEARCH ( TableName[Well], TableName[Origin], 1, FALSE () )
VAR searchTwo =
    SEARCH ( TableName[Well], TableName[Dest], 1, FALSE () )
VAR Result =
    IF (
        searchOne,
        RIGHT (
            TableName[Origin],
            ( LEN ( TableName[Origin] ) - FIND ( ",", TableName[Origin], 1 ) - 1  )
        ),
        IF (
            searchTwo,
            RIGHT (
                TableName[Dest],
                ( LEN ( TableName[Dest] ) - FIND ( ",", TableName[Dest], 1 ) - 1 )
            ),
            BLANK ()
        )
    )
RETURN
    Result

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    5 years ago

    Anonymous -

    This could do the trick as a column:

    Column = 
VAR searchOne =
    SEARCH ( TableName[Well], TableName[Origin], 1, FALSE () )
VAR searchTwo =
    SEARCH ( TableName[Well], TableName[Dest], 1, FALSE () )
VAR Result =
    IF (
        searchOne,
        RIGHT (
            TableName[Origin],
            ( LEN ( TableName[Origin] ) - FIND ( ",", TableName[Origin], 1 ) - 1  )
        ),
        IF (
            searchTwo,
            RIGHT (
                TableName[Dest],
                ( LEN ( TableName[Dest] ) - FIND ( ",", TableName[Dest], 1 ) - 1 )
            ),
            BLANK ()
        )
    )
RETURN
    Result