Data Column URL Remove

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

URL Column Remove.png

Not sure best way to use Dynamic Select to possibly fix....any help would be great!!

URL Column Remove.yxzp

Superstore URL Remove.xlsx

URL Column Remove.png

Datasets

Preparation

Data Investigation

Accepted answers

binu_acs

@DelData the updated workflow attached

URL Column Remove.yxzp

All comments

shancmiralles

hi @DelData ,

if you're doing this in alteryx.. use the select tool :Select: .. and uncheck teh column you don't need.. if the columns that you want are fixed then unselect the "*unknown" column too..

binu_acs

@DelData one way of doing this

URL Column Remove.yxzp

binu_acs

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

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

binu_acs

@DelData the updated workflow attached

URL Column Remove.yxzp

DelData

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703