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

Hi ChrisMcHugh ,

If I took your question correctly then I think you could try below code:-

IF (
    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"
        && VW_STAGING_TO_ACQ_LOAD_DETAIL[TABLE_NAME] = "ROUTES",
    0
)

 

BR,

Samarth

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

    Hi Samarth,

     

    Yes it is along those lines for definite. However, upon trying your code, this is the error I am getting.

     

     

    Is there any way to work around this as I am directly pulling from a column in a dataset

    • 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