Cleaning up csv
- 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
Hey Alteryx-Community,
I'm trying to clean up a list of music performances that I'd like to add to an Alteryx workflow. I am trying to come up with a workflow that appends the information contained in column A to all empty cells up until the next filled cell and then divide the amount that's listed in column E by the total number of performances for that song, so that each line has the correct corresponding amonut next to it. After that i could just filter out all lines that are empty in column B and have a functioning csv, finally.
I feel like this is probably a quick and easy solution but I can't seem to get there. I'd be immensely grateful for some assistance.
Many thanks and all the best,
Matthias
Solved! Go to Solution.
- Labels:
- Help
- Optimization
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @MatthiasBE, how does this look? Let me know if there's any issues! One thing I can think of right away is that you may want to change the rounding of the amounts, depending on the level of precision desired.
- 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
Legend! Thank you so much, David! Exactly what I needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Works perfectly! And I learned something from this, thanks for your help, mate.
