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