How split a table

[Anonymous]

Dear all,

I've ta table with all my maintenance tickets.

I need to create two straight tables, the first one for the new tickets and the second one for the others, like these.

New tickets                       Status                 Others                                   Status

bug_id     bug_description     NEW                 bug_id     bug_description      other status codes

Do I've to create two different tables in  my script ?

I'm sorry but I'm a bit confused

Help please

[tresesco]

Not really. You can get it done in several ways in the front-end.

Using

-Calculated dimension -

For Status dimension use expression like: If(Status='NEW', Status) // and in the dimension tab check 'Supress When Value is Null'

And for second table : If(Status<>'NEW', Status)

-Set Analysis

[kaushiknsolanki · Accepted solution]

Hi,

     You dont need to do anything in script.

     All you have to do is create two straight table.

     1. with dimension as Bug_ID

        and Expression as Only({<Status = {"*New*"}>}Status )

     2 with dimension as Bug_ID

        and Expression as only({<Status -= {"*New*"}>}Status )

Regards,

Kaushik Solanki

[israrkhan]

as tresesco said, dont need to split tables, load as one table.

and easily can do with set analysis, calculated dimensions are slower in performance, if you have large data set.

[#5]

Hi,

If client required separate tables create a two straight tables with the condition of new and old.

Regrads,

Santhosh G

[Anonymous]

Thanks very much !!!