In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Column URL Remove

DelData
9 - Comet

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

9 REPLIES 9
shancmiralles
11 - Bolide

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

binuacs
21 - Polaris

@DelData one way of doing this

image.png

binuacs
21 - Polaris

@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
11 - Bolide

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

apathetichell
19 - Altair

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

 

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

 

would be sufficient.

DelData
9 - Comet

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
9 - Comet

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
21 - Polaris

@DelData the updated workflow attached

 

DelData
9 - Comet

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

Labels
Top Solution Authors