NWA Intactix Users Group
Would you like to react to this message? Create an account in a few clicks or log in to continue.

NWA Intactix Users Group

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

 

 Can I pull back multiple mod traits in one query?

Go down 
2 posters
AuthorMessage
jmiller




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

Can I pull back multiple mod traits in one query? Empty
PostSubject: Can I pull back multiple mod traits in one query?   Can I pull back multiple mod traits in one query? Icon_minitimeWed 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
Eric Liberatore
Admin
Admin
Eric Liberatore


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

Can I pull back multiple mod traits in one query? Empty
PostSubject: Re: Can I pull back multiple mod traits in one query?   Can I pull back multiple mod traits in one query? Icon_minitimeWed 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
http://spaceuser.blogspot.com
jmiller




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

Can I pull back multiple mod traits in one query? Empty
PostSubject: Re: Can I pull back multiple mod traits in one query?   Can I pull back multiple mod traits in one query? Icon_minitimeTue 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
Eric Liberatore
Admin
Admin
Eric Liberatore


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

Can I pull back multiple mod traits in one query? Empty
PostSubject: Re: Can I pull back multiple mod traits in one query?   Can I pull back multiple mod traits in one query? Icon_minitimeTue 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
http://spaceuser.blogspot.com
Sponsored content





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

Back to top Go down
 
Can I pull back multiple mod traits in one query?
Back to top 
Page 1 of 1
 Similar topics
-
» SOTC Traits
» Query Performance data from Retail Link for your Modular(s)

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