Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere are some hints for creating the new tags
1. PARSE the original tag for the tag ending
2. Convert CHARacters to INTegers
3. Determine rows to GENERATE based on range
4. Use some FORMULAs to create a new tag ending
I think it is important to keep the logic simple and easy to follow. If there was a follow up task, like permitting non-consecutive letters (i.e. C123A/B/D), you would need to make small modifications and wouldn't want to come up with an entirely new solution.
My solution for cloud!!
Designer Cloud and Trifacta don't have Generate Row tool. So I use other tool instead.
Designer Experience
Trifacta Classic
Hi @Watermark , the problem lies with the Null values generated after your Text to Columns tool. If you add a Data Cleansing tool and adjust your formula a little, you can get rid of this error. 😉
I'm attaching the workflow if you want to take a look.
I've always wondered how to create the alphabet using the generate rows tool and now I know thanks to this post:
Generate Rows: increment letters like numbers
My solution:
Yep yep yep, the second I read your reply mention nulls I went and tweaked it. Then looked at your flow to see how you handled it, and they were identical. Thanks for the shout!