Forum Discussion

Suryaann's avatar
Suryaann
Frequent Visitor
7 years ago
Solved

Creating a conditional column for repetitive sequence

Hi All,

 

I have a table with number and value column.i want to create another table/column to assign 1 to 8 numbers as SET A and 6 to 15 as SET B.6,7,8 are common for both the sets.The purpose of this new column is to have a filter which shows SET A and SET B.While selecting SET A it should show the details of 1 to 8 and for set b it should show the details for 6 to 15.

 

New table

 

 

Kindly help.

Need Help
Tips and Tricks
  • AlB's avatar
    AlB
    7 years ago

    Hi Suryaann 

    Create a new table:

     

    NewTable =
VAR TabA_ =
    ADDCOLUMNS ( GENERATESERIES ( 1, 8 ), "filter", "SET A" )
VAR TabB_ =
    ADDCOLUMNS ( GENERATESERIES ( 6, 15 ), "filter", "SET B" )
RETURN
    UNION ( TabA_, TabB_ )

    then change the name of the first column as desired

     

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Suryaann 

    Create a new table:

     

    NewTable =
VAR TabA_ =
    ADDCOLUMNS ( GENERATESERIES ( 1, 8 ), "filter", "SET A" )
VAR TabB_ =
    ADDCOLUMNS ( GENERATESERIES ( 6, 15 ), "filter", "SET B" )
RETURN
    UNION ( TabA_, TabB_ )

    then change the name of the first column as desired