[Clug-l] Help in Clementine 10.0

[Joey Dimatulac]

Hello - 
 
I am very new in using SPSS Clementine and I need some help in running my stream. 
 
I am trying to create new records from the result of the output table node:
 
Here is the result of the output table node:
 
Customer ID    PRODUCT     Start_Month       End_Month1234567          Bagel            1                       21234567          Bagel            4                       52345678          Bagel            2                       22345678          Bagel            4                       63456789          Bagel            5                       5
 
 
This is what I am trying to achieve as my new output results
 
Customer ID    PRODUCT     Month     Flag  1234567          Bagel            1             Y           1234567          Bagel            2             Y         1234567          Bagel            3             N         1234567          Bagel            4             Y         1234567          Bagel            5             Y         1234567          Bagel            6             N2345678          Bagel            2             Y2345678          Bagel            3             N2345678          Bagel            4             Y 2345678          Bagel            5             Y        2345678          Bagel            6             Y       3456789          Bagel            5             Y       3456789          Bagel            6             N       
 
I am looking from the start and end months when a customer bought bagels at a store.
 
The new field Month represents calendar month for 1 - 6 months and flag represents whether a customer bought bagel for that month. Whatever the first record of the patient should reflect the start month when he frist bought bagel at a store. 
 
I am not so sure if there is any node that I can use other than the derive node to create these new records from the analysis.
 
Any help you can give will be much appreciated.
 
Thanks and have a great day! 
 
Joey
_________________________________________________________________
Connect and share in new ways with Windows Live.
http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_012008
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cammlist1.spss.com/pipermail/clug-l/attachments/20080314/4192c3a2/attachment.html