How to separate value from the Column

[Mina2021]

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?

[Emil_Kos]

Hi @Mina2021,

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

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

[Mina2021]

Hi Emil_Kos,

what If I want to give two options:

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

2) Only actions - contains only actions

Thank you so much for your help!

[Emil_Kos]

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]

Hi Emil_Kos

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?

[pedrodrfaria]

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.

[Mina2021]

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.

[pedrodrfaria]

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 _

[Mina2021]

Hi @pedrodrfaria 

I getting below error:

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