Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Remove values after "?"

ulysses_no
7 - Meteor

Hi,

I have a report from Google Analytics that I want to wash.  Basically it's the same page, but with different tracking or filter values that gets recorded. 

 

Example:

Page URLViews
/test/test1/test2/ID/Catalog.html?Event=promotemenu471
/test/test1/test2/ID/Catalog.html?Event=filter=1300
/test/test1/test2/ID/Catalog.html?Value=210
/test/test1/test2/ID/Catalog.html?MaxValue=2251

 

I would like to remove everything after "?" AND the views to be summarised like this:

Page URLViews
/test/test1/test2/ID/Catalog.html1032

 

How do I do this?

 

Thanks in advance for your help!

2 REPLIES 2
apathetichell
20 - Arcturus

This should do the trick...

Luke_C
17 - Castor
17 - Castor

Hi @ulysses_no 

 

Here's two options, one regex one with a formula. This assumes only one ? in the URL data.

 

Formula: Uses a Left function with a nested FindString function to take everything left of the ?

Regex: looks for the ? and everything after and removes it (replaces with nothing)

 

Luke_C_0-1621880635660.png

 

 

 

Labels
Top Solution Authors