Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to tile

Hamder83
11 - Bolide

Hi 

I'm trying to group data, and assign each group an id. And each like within that group a line id.

I have Carrier_name, direction and delivery_country_code and scan_date as criteria for main group.

Hamder83_0-1658487932558.png
I assign each of these an ID

Hamder83_1-1658488000430.png

 

Then each parcel number should have a ref to the LM_Scan_group
And have a forth running number within that group.

Hamder83_2-1658488267966.png

 

Desired result

Hamder83_3-1658488502322.png



I have attached sample workflow with sample data.


Thanks in advance, 

 

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @Hamder83,

Here are the settings I used:

IraWatt_1-1658488871605.png

Notice I ticked leave unsorted as otherwise it was ordering by date. I also set the group to the date as I assumed by you example that's what you wanted. 

 

If you right click on Tile there are some great examples there:

IraWatt_2-1658488950703.png

 

Any questions or issues please ask :)
HTH!
Ira

 

 

 

Hamder83
11 - Bolide

Hi @IraWatt , that works....

Im not sure how tho, if I fill both carrier_name and direction on top of country code and scan date - i get as many results as with country and scandate only.

I thought if I took country and scan date only, it would merge all carriers within that group to 1?

Hamder83_2-1658490215828.png

But I will look deeper into that tool. Thank you very much :-)

 

Labels
Top Solution Authors