SOLVED
How to concatenate a string to an Alteryx Tool generated RecordID
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
FogoFortitude
7 - Meteor
‎03-05-2017
03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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]
Solved! Go to Solution.
Labels:
2 REPLIES 2
17 - Castor
‎03-05-2017
03:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎03-05-2017
04:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
