Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to separate value from the Column

Mina2021
8 - Asteroid

Hello there,

 

I am wondering how to separate "Date Diff_ " from the Column "Name"! Need to keep all Actions in one side.

Can anyone suggest me on this?

 

Mina2021_0-1616658811895.png

 

8 REPLIES 8
Emil_Kos
17 - Castor
17 - Castor

Hi @Mina2021,

 

You need to use the below formula to make it work.

 

!Contains([Name], 'Date Diff')

 

Emil_Kos_0-1616660216679.png

 

Mina2021
8 - Asteroid

Hi ,

 

what If I want to give two options:

 

1) Both actions & date diff - Contains data actions & date diff

2) Only actions - contains only actions

 

Mina2021_0-1616662805849.png

 

 

Thank you so much for your help!

Emil_Kos
17 - Castor
17 - Castor

Hi @Mina2021,

 

IF you want to give a user possibility to pick how the filter should work you need analytical app. Please see attached workflow for inspiration. 

Mina2021
8 - Asteroid

Hi 

 

This is amazing - thank  you! I applied the example and worked well.

 

I have one more query-

 

How can I separate the date extension from the "Webinar" from Under Value col?

 

 

 

Mina2021_2-1616675692001.png

 

 

 

 

pedrodrfaria
13 - Pulsar

Hi @Mina2021 

 

To separate that see below, it is pretty simple, use the text to columns with the _ as the separator.

 

If the Value column does not always have the _ but has the data structure of "WORD" "DATE", EX: webniar20200101. You can also use the Regex to parse it out:

 

(\w*)\s*(\d*)

 

If you need to put the date in the date format, you can either use the formula or the datetime tool. Formula gives you more options and flexibility. The datetimetool may be easier to understand if you are learning alteryx right now.

 

 

pedrodrfaria_0-1616675869953.png

 

Mina2021
8 - Asteroid

Hi @pedrodrfaria

 

Thank you for quick response!

 

I am familiar with the Text to column tool.I want to do it with formula or filter tool with the word ''Replace". Can we do that?

 

Replace([Value], Webinar_YYYYmmDD, 'Webinar') - this formula i am trying.

 

I need to do only for the "Webinar_yyyymmdd" not for every value.

Mina2021_0-1616676542009.png

pedrodrfaria
13 - Pulsar

If you want to use the formula tool, here is the function:

Replace([Field1], 'Webinar', '')  if you want to keep the _

 

 

Replace([Field1], 'Webinar_', '') if you want to remove the _

 

pedrodrfaria_0-1616676549163.png

 

Mina2021
8 - Asteroid

Hi @pedrodrfaria 

 

I getting below error:

Mina2021_0-1616681505644.png

 

I am trying to remove "_date extension" from "Webinar_20210112".

after removing the "_date extension"

output should be:

 

Value

Webinar

e-detail

webinar

e-detail

 

Labels