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...
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

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