Hi all,
I’ve been trying to use the MultiColumnRename gem, but I can’t get it to work. My goal is to rename columns by replacing all spaces " " with underscores "_"
any example would be appreciated thank you.
1 Like
Hi @Mukeshy12390,
I’ve attached screenshots for what I believe you’re trying to accomplish. One screenshot is in the ‘Visual’ view and the other is in the ‘Code’ view of the configuration of the MultiColumnRename gem.
The main thing to note is that when you select the Advanced Rename option you will want to create an expression to do the type of rename you want. You need to use column_name to represent the columns you’ve selected to apply the renames to.
Documentation on the MultiColumnRename:
Let me know if you have more questions.
2 Likes
thanks it worked !, can i create my temp manual data or import in prophecy? for testing what is best way to do this without accessing cloud drive or other application ( only I have desktop files)
@Mukeshy12390 - Yes, you can do this with a seed table. This is what I used in my example above. To create a seed table select the Table gem and then select seed type. In the Properties screen you can either type in the data you want to test on or you can even drag a csv that already has data in it into this screen.
Documentation link: