Append A Character N Times For Each Record

More
6 years 2 months ago #16892 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?

Please Log in or Create an account to join the conversation.

More
6 years 2 months ago #16893 by Peter.Jonson
Five minutes job with Accumulate Strings

www.etl-tools.com/wiki/aetle/transformat...ions/miscellaneous?s []=accumulate#accumulate_strings




Peter Jonson
ETL Developer
Attachments:

Please Log in or Create an account to join the conversation.