Lounging By the Beach

[CES]

I'm sorta caught up...for the moment


I like Lynryd Skynyrd


(...except for that song. it reminds me of moving here from miami kicking and screaming ...thanks for the thought though )

but you have to see this version....hehehehehe

 

[SilverBear]

This is really going to bore the other beachgoers. So go ahead and skip reading this.

OK... it's a "product cross-sell" problem. I need to know what products people buy together. And my solution is working MOST of the time.

Say somebody buys 2 products in 1 order. That is 1 order, two items. I create 2 records... one with Product A as "Product 1" and Product B as "Product 2"... the other record has Product B as "Product 1" and Product A as "Product 2".

If they bought 3 items, I end up with six records... all combinations of Products A, B and C.

And this works for my purpose.

HOWEVER, there are rogue occasions the query does NOT work. A 2-product purchase only yields ONE record. And it only happens with one particular product. But not EVERY time.

 

[SilverBear]

There are currently 1 users browsing this thread. (1 members and 0 guests)

I bored everybody right out of here!!!

Sigh.

 

[JustaGuy]

CES! The hair!

Yeah, I know that song gets played to death too, but it's so classic.

Any chance you can find a transfer back to Miami?

 

[CES]

Don't you just love the red army choir in the background. I laughed like crazy the first time i saw it.

The miami option is long gone. I like it here now- and i like what i do. that's why i stayed here instead of moving back to miami for a postdoc.


Bear- that actually made sense to me. trying to figure out the puzzle would need a glass of wine (or 3) to deal with though.

 

[JustaGuy]

This is really going to bore the other beachgoers. So go ahead and skip reading this.

OK... it's a "product cross-sell" problem. I need to know what products people buy together. And my solution is working MOST of the time.

Say somebody buys 2 products in 1 order. That is 1 order, two items. I create 2 records... one with Product A as "Product 1" and Product B as "Product 2"... the other record has Product B as "Product 1" and Product A as "Product 2".

If they bought 3 items, I end up with six records... all combinations of Products A, B and C.

And this works for my purpose.

HOWEVER, there are rogue occasions the query does NOT work. A 2-product purchase only yields ONE record. And it only happens with one particular product. But not EVERY time.

Not getting into too much detail, in a relational database, each order would compose of one to many "detail lines", each representing one item or product. I assume the purchase records were created, 2 detail lines, 2 records in a table. That's important. If that was the case, then it's just the query parameters.

 

[starrynight]

Not getting into too much detail, in a relational database, each order would compose of one to many "detail lines", each representing one item or product. I assume the purchase records were created, 2 detail lines, 2 records in a table. That's important. If that was the case, then it's just the query parameters.

Yeah I was gonna say that too but JaG beat me

 

[Fudgey]

Afternoon on the beach

Whis.....forgot to tell you that video was awesome!!!

 

[JustaGuy]

Don't you just love the red army choir in the background. I laughed like crazy the first time i saw it.

The miami option is long gone. I like it here now- and i like what i do. that's why i stayed here instead of moving back to miami for a postdoc.


Bear- that actually made sense to me. trying to figure out the puzzle would need a glass of wine (or 3) to deal with though.

Yeah, see how well known that classic is? Perhaps they're dying to move to Bammy?

But don't you miss the weather and ocean?

 

[starrynight]

Afternoon on the beach

Whis.....forgot to tell you that video was awesome!!!

Fudgey!! I watched it too, that guy doesnt really fall at the end right?

 

[CES]

Yeah I was gonna say that too but JaG beat me

yeah, me too Starry. Heya

good afternoon in here Fudgey

 

[JustaGuy]

Yeah I was gonna say that too but JaG beat me

Starry starry ni...day, day!!

 

[starrynight]

yeah, me too Starry. Heya

good afternoon in here Fudgey

...........

 

[CES]

Yeah, see how well known that classic is? Perhaps they're dying to move to Bammy?

But don't you miss the weather and ocean?

...and the citrus in the back yard, and sunshine, and...and... sigh.

 

[SilverBear]

Yes... the raw data file from the financial system has 1 record per product. There can be more than 1 product in an order. And the query runs against that data to create a record for every combination. 2 items yield 4 records, 3 make 6, etc. 1 item yields 1 record.

But not every time when a certain item is involved... and then it's sporadic.

This is not beach material... I shall leave everybody alone!

 

[JustaGuy]

Afternoon on the beach

Whis.....forgot to tell you that video was awesome!!!

Hello Fudgey who melts for no one!

 

[JustaGuy]

yeah, me too Starry. Heya

good afternoon in here Fudgey

...and the citrus in the back yard, and sunshine, and...and... sigh.

It'd be a big move, but...the hardest part of life is deciding what we really want, I guess.

 

[JustaGuy]

Yes... the raw data file from the financial system has 1 record per product. There can be more than 1 product in an order. And the query runs against that data to create a record for every combination. 2 items yield 4 records, 3 make 6, etc. 1 item yields 1 record.

But not every time when a certain item is involved... and then it's sporadic.

This is not beach material... I shall leave everybody alone!

So your query creates new records in a result table, and the additional record is missing?

Two suggestions:

1. make a copy of that query and make it select/normal query instead, do not create records, just see what it gets.
2. check query setting for "unique records". It may think it's a duplicate and not create it again.

But I'd still look into search parameters using #1 above. When in doubt, deconstruct...

 

[JustaGuy]

Ok, Bear, you and I have chased all the ladies away with our database talk!


Hey, girls, did you know databases can be sexy?

 

[CES]

Home is here for the foreseeable future- at least another few years til i get vested in the retirement system. My friends and support system are here too.

Bear, you don't have to leave...I'm curious. anyway you can work on the beach


(this is so cool...my laptop froze and it's restarting, but in the meantime i switched to my tablet...and it restores my post ^^^)