Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Creating weight classes getting price from a difference source

Highlighted
8 - Asteroid

Hi 

I'm trying to create a price table for a customer of mine.

The case is, i get a ID key from source 1:
ShipmentYear - Customer name - Freight service - Delivery country - Weight 

From that Id line key i wanna get the price, which is stored in a excel file.

So i want to be able to add the excel file as data source and do a lookup based on the ID line key from my original source.


ID - line KEYDelivery CountryAmount per unitCurrencyStart WeightMax WeightWeight Class
2019Customer ApSUB Parcel Business GLS DEFreightDEDE33,5DKK0,000,49A



So something like this:

SELCT [Amount per unit] 
WHERE 
Source.Weight BETWEEN [Start Weight] AND [Max Weight] 


... Do I make any sense?

Highlighted
6 - Meteoroid
Hi,

Have you tried using the join tool and joining on ID which will create an inner join giving you the data from both data sources.

Kind regards
Highlighted
8 - Asteroid

Hi 

Today I have a id line key with customer - product - delivery country and weight

Which means For each product (sold in 500G weight intervals)
I need
2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE1

2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE2

2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE3

2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE4

2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE5

2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE6

 

and so on ... 

What i wanna do is group them 
because if 2019Society of Lifestyle ApSGLS Germany ParcelUB Parcel Business GLS DEFreightDE 1-5 have the same price, I dont wanna have 5 lines.


Because i have 100+ product, on 60 customers, with weigt from 0-100 kilo.
And that gives a million price lines.

So i wan to be able to extract the price, from a weight range in my price file

Highlighted
8 - Asteroid

Hi 

I've tried creating some test data to show what i mean.

in the idlinekey file, i want to get the price from CustomerPricing 

based on idlinekey where weight is between start and max weight.

If possible?

 

Highlighted
12 - Quasar

Hi @Hamder83 ,

 

After join on id/key  use filter  . 

Filter 

[Weight] >= [Start Weight] and
[Weight] <= [maxWeight]

clipboard_image_0.png

Labels