This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to give a group of data a specific number. For instance:
Record ID Ownership Del Pt Name Address State Store #
1 20 12345678 Ben's Candy Barn 1 Horseshoe Lake ON 1
2 1220 12345678 Ben's Candy Barn 1 Horseshoe Lake ON 1
3 890 220789 Ben's Candy Barn 1 Horseshoe Lake ON 1
4 1220 12376789 Ben's Candy Barn 1 Promenade Dr MB 2
5 890 220899 Bens Candy Barn 1 Promenade Dr MB 2
6 20 12376789 Ben's Candy Barn 1 Promenade Dr MB 2
In other words, if the next address and state below are the same, give it the same number as the one number above, if not give it the next sequential number.
I used the Record ID tool to give it the record number. I think I can accomplish this by grouping and using the Multi-Row tool, but I think I've tried so many things, I've totally confused myself. Is this even possible? If so, how do you even get it started? Among others, I've tried:
If [address_line_1] and [state] !=[address_line_1] and [state] then [Record ID] else [Row+1: Record Id] end if
I'm confused! Any help would be greatly appreciated.
Hi there. One of my favorite tools which you can use here is the Tile tool. I kind of abbreviated your data set. I often play with the parameters in the Tile tool. I used the drop down to select "Unique" for your address and state. You can also try grouping by fields too if needed, but I didn't in this case. I just listed that your address and state would need to be unique. You get not only a 1 for the first set of addresses and a 2 for the next, but you also get a sequence within that set (1,2,3). You can rename them with a Select. Hope that helps.