Removing "" from entire dataset
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Is there any way to remove "" from all the records at once? I imported .txt file using \0 delimiter and so the quotes came in as well.
StripQuotes works but I have 100+ fields in my data set. I would have to do it all one by one.
Data Cleansing won't work because I want to keep all other punctuation in my data.
Please help!
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use a multi-field formula just like you would a regular formula but point it at "current_field" and select all fields.
Good luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What about using transpose, strip quotes and then crosstab back?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Blake ,
Thanks for your solution.
Can you help me configure the tool?
I haven't used this tool much.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
originally i suggested the data cleansing tool, did not see your comment about it. i would suggest what @DiegoParker recommended
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DiegoParker ,@Bpatel,
Thanks for replying.
I tried that. For some reason, it's not removing all the "" from the column.
Do you why this is happening or if you have any other solution for the problem?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@rajputakansha @bpatel @DiegoParker
Alteryx is great because we can all solve the same problem in different ways. I think in this case it is best to keep it simple.
If you look at performance profiling for a problem like this, the crosstab along can take up to 4x longer to run than the multifield formula.
If you want to only remove the quotes from each end of the field, you can use stripquotes([current_field]) in the multirow formula instead of the replace function.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
