Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
16 - Nebula

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