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 ...
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

     

     

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