How to separate value from the Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 _
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)