Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Comparing Product Demand and Date Availability Tables

KevinAtGuest
5 - Atom

Hi all,

 

I have two tables, one for product demand, and one with product availability dates - how would I pull the date at which point a product will have a greater quantity available than demand, adding it to the Demand table? Thanks!

 

 

Demand

ProductDemand QuantityRunning Total Demand
A1515
A2540
A1454
A1670
A1888
A32120
A10130
B1818
B2038
B2260
B3595
B70165
B15180
B30210
C3030
C1444
C2872
C34106
C33139
C21160
C35195

 

Availability

ProductAvailable QuantityRunning Total Available QuantityDate Available
A333311/17/2021
A154811/24/2021
A307812/1/2021
A2310112/8/2021
A2112212/15/2021
A1914112/22/2021
A2016112/29/2021
A281891/5/2022
B161611/17/2021
B173311/24/2021
B144712/1/2021
B307712/8/2021
B3911612/15/2021
B3615212/22/2021
B2217412/29/2021
C252511/17/2021
C234811/24/2021
C307812/1/2021
C3911712/8/2021
C3014712/15/2021
C1416112/22/2021
C3119212/29/2021
3 REPLIES 3
Pingu
10 - Fireball

Is it based on Running Total demand? I think you would have to join the data based on product, then compare the demands and look up the date value.

 

I mocked up a draft, let me know what you think. This assumes it will look up the first date when there is enough availability. There is also 3 lines where the running total demand is higher than the availability. You could add those again using union tool.

 

Pingu_0-1637162858814.png

 

afv2688
16 - Nebula
16 - Nebula

Hello @KevinAtGuest ,

 

It might not be the optimal solution but it works 🙂

 

Untitled.png

 

Hope it helps

 

Regards

KevinAtGuest
5 - Atom

Great, thanks! @afv2688 & @pingu. AFV's solution worked best for my scenario, appreciate both of your input

Labels
Top Solution Authors