Alteryx Designer Desktop Discussions

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

Data Column URL Remove

DelData
8 - Asteroid

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
8 - Asteroid

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
8 - Asteroid

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
8 - Asteroid

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

Labels
Top Solution Authors