Forum Discussion

gcongrove's avatar
gcongrove
Frequent Visitor
6 years ago
Solved

Evaluate data from multiple rows to create a new value

Hello. I have a table with the following layout: Provision basis User installed Install everywhere         2 0 0         0 0 0         1 0 0 ...
Need Help
  • gcongrove's avatar
    gcongrove
    6 years ago

    I was able to figure it out on my own:

     

    TestColumn =

    SWITCH (

        TRUE (),

        a_win10CTV_overview[ProvisioningBasis] = "2" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","Wont Display",

        a_win10CTV_overview[ProvisioningBasis] = "0" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Install",

        a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Approval required",

        a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "1" && a_win10CTV_overview[InstallEverywhere] = "0","Manual Install"

    )

gcongrove's avatar
gcongrove
Frequent Visitor
6 years ago

I was able to figure it out on my own:

 

TestColumn =

SWITCH (

    TRUE (),

    a_win10CTV_overview[ProvisioningBasis] = "2" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","Wont Display",

    a_win10CTV_overview[ProvisioningBasis] = "0" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Install",

    a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "0" && a_win10CTV_overview[InstallEverywhere] = "0","SCCM Approval required",

    a_win10CTV_overview[ProvisioningBasis] = "1" && a_win10CTV_overview[UserInstalled] = "1" && a_win10CTV_overview[InstallEverywhere] = "0","Manual Install"

)