NWA Intactix Users Group

For users of Intactix software in the NW Arkansas region and beyond
 
HomeCalendarGalleryFAQSearchRegisterMemberlistUsergroupsLog in

Share | 
 

 Can I pull back multiple mod traits in one query?

View previous topic View next topic Go down 
AuthorMessage
jmiller



Number of posts : 5
Location : Bentonville
Company : US Nutrition
Title : Category Development
Registration date : 2008-05-08

PostSubject: Can I pull back multiple mod traits in one query?   Wed Nov 12, 2008 9:49 am


When pulling sales by mod in RLink, can I pull back multiple mod traits in one query or do I have to query them separately?

It would be nice to pull them back all at once, then Pivot Table to see them individually.
Back to top Go down
View user profile
Eric Liberatore
Admin
Admin
avatar

Number of posts : 489
Location : Bentonville, Akansas, USA
Company : Clorox
Title : Planogram Development Manager
Registration date : 2006-11-16

PostSubject: Re: Can I pull back multiple mod traits in one query?   Wed Nov 12, 2008 10:27 am

Yes. In a store detail query you will need to add the column Modular Plan Desc. It's found under Item Information/Store Unique Modulars.

Another way is to pull them by Sel Store Trait. This will bring your sales results back by trait number (obviously). You will need to copy and paste all modular traits into your Send Traits filter on the Store Selection portion of the query.
Back to top Go down
View user profile http://spaceuser.blogspot.com
jmiller



Number of posts : 5
Location : Bentonville
Company : US Nutrition
Title : Category Development
Registration date : 2008-05-08

PostSubject: Re: Can I pull back multiple mod traits in one query?   Tue Dec 16, 2008 12:27 pm

Thanks for the tip. I queried using the Modular Plan Desc, but why does it show one blank Modular Plan for every item?

So if I pull "item A" it will give me sales on 8 different Modular Plan Descriptions, but there is always one row for every item showing sales that has a blank for the Modular Plan Description. Why is that?
Back to top Go down
View user profile
Eric Liberatore
Admin
Admin
avatar

Number of posts : 489
Location : Bentonville, Akansas, USA
Company : Clorox
Title : Planogram Development Manager
Registration date : 2006-11-16

PostSubject: Re: Can I pull back multiple mod traits in one query?   Tue Dec 16, 2008 12:30 pm

These are sales where the stores don't have this item on their planogram. The store may have had the item on a previous planogram and still has inventory to sell through.
Back to top Go down
View user profile http://spaceuser.blogspot.com
Sponsored content




PostSubject: Re: Can I pull back multiple mod traits in one query?   

Back to top Go down
 
Can I pull back multiple mod traits in one query?
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» [Help] how to add multiple testcases in a TestSuite through Selenium IDE
» I need these colors changed
» Laid-Back Monthly Photo Contest *Canada and usa only*
» Back to School In-Style Sweepstakes
» Back to School Sweepstakes *Michigan and Wisconsin only*

Permissions in this forum:You cannot reply to topics in this forum
NWA Intactix Users Group :: Tips N Tricks :: Retail Link-
Jump to: