How to concatenate a string to an Alteryx Tool generated RecordID

[FogoFortitude]

Hi, 

For some reason when I attempt to concatenate a string prefix to my record id the extended string is cut short. 

For example: 

1. Set up Record Id of length 6 as a string

2. Using Formula ID I use the formula below to verwrite the RecordID field...the data preview show me what I want which is EB_000001. However, when Formula runs the results of every RecordID is EB_000?

 "EB_"+[RecordID]

[patrick_digan · Accepted solution]

Since recordid is a string of size 6, it will only keep the first 6 characters from for formula. The data preview must not be factoring that in. You could either add a select tool before your formula to change the size, or create a new field in your formula tool that's a bigger size.

[FogoFortitude · Accepted solution]

Thanks Patrick,

The work around I used involved the same steps as before except instead of assigning it to the existing RecordID field to be updated created a new System of Record Id column and then dropped the RecordID tool generated column via the Select Tool.