Creating dummyID with growing aritmetical progression

[Paolo1993]

Hi all guys, hope it's a good starting day for everyone. 

Quick one for you about Alteryx.

I would like to create two columns which have dummy_ID info coming from the previous one as I need to make unreadable some sensible data. 

I managed to do that, but I can't add the growing progression. 

(Find below what I meant). 

Let's say I have 3 rows and 2 columns:

Position	Job	Dummy_Position	Dummy_Job
Managerial	Manager	Position1	Job1
Support	Clerk	Position 2	Job2
Support	PA	Position 3	Job 3

I would like to create the Dummy_Position and Job columns with growing progression per each position and job

(Position1, Position2, Position3 etc and same for Dummy_Job).

Can you please help me?

MANY THANKS!

P

[neilgallen]

You can create a record I’d, then use the formula tool to write a string field that combines it to create a new string value ([field]+[record ID]).

alternatively, you could use the multi row formula tool but the formula would be more complex. 

Sorry for the brief response as I’m on my phone!  Good luck. 

[MarqueeCrew]

@Paolo1993,

I agree with @neilgallen.  You do however need to convert the RecordID to a string.  If you first define it as a string, you'll get 000001.  That's not what you're after however.

Position + ToString([RecordID])

Then you can eliminate the RecordID field.

Cheers,

Mark

[BenMoss · Accepted solution]

I think Mark has answered your question but an additional response from myself would be do you want to create a consistent position and job 'dummy ID', in that you have support twice, instead of incriminating the position_DummyID field in that instance should it be the same (I appreciate in your example data it isn't like this but perhaps it was a mistake)? I may be wrong but just want to clarify!

To me it sounds like you are trying to sensitize your data without loosing it's 'integrity'. 

If you are looking for what I have suggested a solution is attached.

Ben

[Paolo1993]

Thank you all guys! This definitely solved my problems, you're always the best!

Have a wonderful day! :)