- Posts: 3
- Thank you received: 0
Append A Character N Times For Each Record
6 years 2 months ago #16892
by Esteban
Append A Character N Times For Each Record was created by Esteban
Hi Guys,
I have a requirement where I would have to repeat a special character in increasing order for each line, like below.
Serial.No Type
1 Apple#
2 Apple##
3 Apple###
4 Apple####
5 Apple#####
Can any of your software can do it?
I have a requirement where I would have to repeat a special character in increasing order for each line, like below.
Serial.No Type
1 Apple#
2 Apple##
3 Apple###
4 Apple####
5 Apple#####
Can any of your software can do it?
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
6 years 2 months ago #16893
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Append A Character N Times For Each Record
Five minutes job with Accumulate Strings
www.etl-tools.com/wiki/aetle/transformat...ions/miscellaneous?s []=accumulate#accumulate_strings
www.etl-tools.com/wiki/aetle/transformat...ions/miscellaneous?s []=accumulate#accumulate_strings
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.