Creating a conditional column for repetitive sequence

[Suryaann]

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.

[AlB · Accepted solution]

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