Data Column URL Remove
- 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
Can you help?
I get data where i sometimes get a lot of columns....some columns only contain url's and i dont need these.
the example excel shows 10 columns...I want to keep the Green columns but remove the 2 Orange columns that only contain a URL address or blank/nulls data.
So Column Select A and Select B will be removed since they only contain combination of URL addresses or Blank/Empty cells.
Column Order ID, Order Date, Ship Date, Ship Mode, Select C, Customer ID, Customer Name and Segments will be kept.
Select C will be keep since it contains some URLs but also some Non-URL data....so i need to keep Select C..
Not sure best way to use Dynamic Select to possibly fix....any help would be great!!
Solved! Go to Solution.
- Labels:
- Data Investigation
- Datasets
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @DelData ,
if you're doing this in alteryx.. use the select tool .. and uncheck teh column you don't need.. if the columns that you want are fixed then unselect the "*unknown" column too..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData one way of doing this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@shancmiralles your solution should work if the columns are fixed for dynamic columns we need a different approach , i used the dynamic select tool for this with a batch macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yeah thanks! i just based my answer from the screenshot. not in my pc right now to see the other attachements.. thanks! @binuacs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dynamic Select is a personal favorite. I mean current situation just something like
!([Name] in ("Select A","Select B"))
would be sufficient.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for replying with help....i when i downloaded attachment i only see my original sample workflow....
Also...the number of columns can vary on the input i receive.......thanks for your help and getting back to me 👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for replying with help....i will work with dynamic select as you mention....this will help me and thanks for taking time to reply...👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DelData the updated workflow attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you...this worked perfectly...thank you for taking time to help 😀
![](/skins/images/1A7F54316481E10DBCA4A87A32E06CC6/responsive_peak/images/icon_anonymous_message.png)