Forum Discussion

ChrisMcHugh's avatar
ChrisMcHugh
Icon for Helper I rankHelper I
4 years ago

Use an IF on a column containing string value that if it returns true, returns a number

IF(AND(AND(AND(AND(VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] = "LOADED", (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "PARTIALLY LOADED"), (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "FAILED...
Need Help
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

ChrisMcHugh Please update it as:-

IF (
    MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) = "LOADED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) <> "PARTIALLY LOADED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) <> "FAILED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[TABLE_NAME] ) = "ROUTES",
    0
)
ChrisMcHugh's avatar
ChrisMcHugh
Icon for Helper I rankHelper I
4 years ago

Yes it seems to be working to some extent! I will have to nest IF and IFELSE for different conditions but the basics of it are correct, thank you