Use Tile tool with 1 field (some blanks) or 2 fields

Hello everyone,

I am new to the world of Alteryx and need some assistance.

Here is my scenario:

I have a file with Account numbers and Tax ID. Sometimes we may have setup multiple Accounts with same Tax ID and some with Tax ID blank.

I need to group all accounts with same Tax ID as Tile 1 with Sequence number. ==> This works perfectly for all data that has Tax ID.

However where tax ID is blank, it marks all of them as same Tile Number. <== For this I need either unique tile number for each blank Tax ID record or use Account Number (as an alternate field) to generate unique tile numbers.

Input data and expected results

Input data and expected output

However, what I get as my output is as follows (in orange):

1. It sorts my data. I would like to avoid that if possible.

2. It marks all blanks as same tile after sorting. Need unique for each blank

2019-07-01 15_22_23-Start.png

Any assistance is appreciated.

regards

Gaurav

Datasets

Accepted answers

andyuttley

Hey @gshah

Yes, just two things you'll need to do here:

1 - add in an IF statement to populate your blank Tax ID

2 - there is a 'Leave Unsorted' check box, but this (from what I've seen) impacts the logic within the tool (i.e. it'll sort then just check if the row(s) above match), which doesn't give you the output you want. So instead, leave this unchecked (so it still finds later instances) but put a record ID at the start, and sort by that again at the end: