Data Column URL Remove

[DelData]

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!!

[shancmiralles]

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..

[binuacs]

@DelData one way of doing this

[binuacs]

@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

[shancmiralles]

yeah thanks! i just based my answer from the screenshot. not in my pc right now to see the other attachements.. thanks! @binuacs 

[apathetichell]

Dynamic Select is a personal favorite. I mean current situation just something like 

!([Name] in ("Select A","Select B"))

would be sufficient.

[DelData]

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 👍

[DelData]

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...👍

[binuacs · Accepted solution]

@DelData the updated workflow attached

[DelData]

Thank you...this worked perfectly...thank you for taking time to help 😀