# I need help about this scenario **URL:** \ **Category:** Community Support\ **Tags:** kdb-and-q\ **Created:** [July 8, 2009, 6:43pm UTC](https://forum.kx.com/t/i-need-help-about-this-scenario/6135 "2009-07-08T18:43:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Iris2](https://avatars.discourse-cdn.com/v4/letter/i/e47774/32.png) [@Iris2](https://forum.kx.com/u/Iris2)\ **Post date:** [July 8, 2009, 6:43pm UTC](https://forum.kx.com/t/i-need-help-about-this-scenario/6135/1 "2009-07-08T18:43:00Z")
Received: by 10.150.123.14 with SMTP id v14mr1633640ybc.27.1247074986983; Wed, 08 Jul 2009 10:43:06 -0700 (PDT)Date: Wed, 8 Jul 2009 10:43:06 -0700 (PDT)X-IP: 204.152.180.10User-Agent: G2/1.0X-Google-Token: sIHSLgwAAADXT2KP5zJsdvqY5p7jDBrFX-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1,gzip(gfe),gzip(gfe)X-HTTP-Via: 1.1 webwasher (Webwasher 6.8.3.4533)Message-ID: \<9e23b1fc-cbdb-45a3-a834-dae2e6e6d1ea@u16g2000pru.googlegroups.com\>Subject: I need help about this scenarioFrom: Iris \To: “Kdb+ Personal Developers” X-Google-Approved: [charlie@kx.com](mailto:charlie@kx.com) via web at 2009-07-08 17:44:34Hi,I am new on KDB+ now.I want to know ungroup in some details. In my table, I use that butalways meet an error.Any special issue for using ungroupFor instance,my table issym, exp\_year, exp\_month, strike, exchangelistI want to ungroup to make each line just include one exchangename …\ ---
**Author:** ![felix1](https://avatars.discourse-cdn.com/v4/letter/f/3e96dc/32.png) [@felix1](https://forum.kx.com/u/felix1)\ **Post date:** [July 8, 2009, 6:50pm UTC](https://forum.kx.com/t/i-need-help-about-this-scenario/6135/2 "2009-07-08T18:50:00Z")
X-Mailer: Apple Mail (2.935.3)make all cols except exchangelist primary keys and ungroup them:ungroup 5!0!tableOn 8 Jul 2009, at 20:43, Iris wrote:\>\> Hi,\> I am new on KDB+ now.\> I want to know ungroup in some details. In my table, I use that but\> always meet an error.\> Any special issue for using ungroup\> For instance,\> my table is\> sym, exp\_year, exp\_month, strike, exchangelist\>\> I want to ungroup to make each line just include one exchange\> name …\>\> \> ---
**Author:** ![Iris2](https://avatars.discourse-cdn.com/v4/letter/i/e47774/32.png) [@Iris2](https://forum.kx.com/u/Iris2)\ **Post date:** [July 8, 2009, 8:32pm UTC](https://forum.kx.com/t/i-need-help-about-this-scenario/6135/3 "2009-07-08T20:32:00Z")
User-Agent: G2/1.0X-Google-Token: F\_wRqQwAAAAFFfveHVuLb0wBjBl69rZMX-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1,gzip(gfe),gzip(gfe)X-HTTP-Via: 1.1 webwasher (Webwasher 6.8.3.4533)Message-ID: Subject: Re: I need help about this scenarioFrom: Iris \To: “Kdb+ Personal Developers” X-Google-Approved: [charlie@kx.com](mailto:charlie@kx.com) via web at 2009-07-08 19:36:09thanks. It works now!!On Jul 8, 12:50 pm, Felix Lungu \ wrote:\> make all cols except exchangelist primary keys and ungroup them:\>\> ungroup 5!0!table\>\> On 8 Jul 2009, at 20:43, Iris wrote:\>\>\>\> \> Hi,\> \> I am new on KDB+ now.\> \> I want to know ungroup in some details. In my table, I use that but\> \> always meet an error.\> \> Any special issue for using ungroup\> \> For instance,\> \> my table is\> \> sym, exp\_year, exp\_month, strike, exchangelist\>\> \> I want to ungroup to make each line just include one exchange\> \> name …\\