Platform

Platform

 View Only

  • 1.  Check for {Various}

    Posted Thu March 19, 2020 10:37 PM

    Is there a quick way to check for {Various} across all columns of a master table?







    #TBMStudio


  • 2.  Re: Check for {Various}

    Posted Tue March 31, 2020 08:54 AM

    Hi @Jaitabh Jewel Sharma,

     

    You could append all columns to a new single column and then doing a Find command looking for {Various} on that column.

    Use export to get all column names and put & character between them.

     

    PS you do not want to edit this into the master table.

     

    Cheers,

     

    Robert


    #TBMStudio


  • 3.  Re: Check for {Various}

    Posted Tue March 31, 2020 06:10 PM

    @Robert Brilmayer ... whilst this may work, I'm more after specifically checking for {Various} on Master Datasets, as those are the ones we build reports from. 


    #TBMStudio


  • 4.  Re: Check for {Various}
    Best Answer

    Posted Tue April 07, 2020 10:21 AM

    If you make a copy of the columns of the master table and append it to the master data set you can create a seperate column with all column in the pre-master data set. Then use that to find a various in that column and hide the column and show the FIND result in the master...

     

    Does that make sense?


    #TBMStudio


Related Content