extract using delimiters

[viditverma62]

I have a data : ABC|001|BCE|2021 - Video-view-impressions-abc

i want to extract the data for first 4 delimiters pipes , i want to ignore after the hyphon

[viditverma62]

its working perfectly. Thank you

one small help.

i have some rows of data that contains the text "Truepost" there are thousand of rows coming with name that contains the word "Truepost" so, I want, all the rows that contains the word/text "Truepost" to be categorized under "YouTube" (in different column)

and in one column the campaign name to be output as:

KTO|VB|007|League 1: Cut|2021

STO|AB|002|League of Word: Cut|2021

BTO|DR|009|League: Cut|2021

Raw Data

1. KTO|VB|007|League 1: Cut|2021|Premiere|Trailer #3|3.15|Truepost2.0

2. STO|AB|002|League of Word: Cut|2021|Premiere|Trailer #2|5.15|Truepost1|UnderArm_01

3. BTO|DR|009|League: Cut|2021|Premiere|Trailer #2|8.18|Truepost

[apathetichell]

formula tool

new column - youtube - type boolean

if contains([field1] ,"Truepost") then True else False endif

Try that? Then you can filter on it later.

[field1] is whatever your field is called.

[viditverma62]

Thank you so much for this help. i am able to do it perfectly. i am a newby in alteryx 

i have a small query. i have the data for two campaigns in excel file, i want the minimum date and maximum date for these two campaigns, may i know how to calculate the max and minimum date?

lets sat date format here is mm/dd/yyyy

Campaign Name                                Campaign running date

     ABC|Friend|2021|ETD                         1/2/2020

     CBF|Reunion|2021|ETD                         2/4/2021

     CBF|Reunion|2021|ETD                         4/5/2021

     ABC|Friend|2021|ETD                         5/23/2021

     ABC|Friend|2021|ETD                         7/5/2021

     CBF|Reunion|2021|ETD                        5/29/2021

[apathetichell]

no problem! you can even take multiple mins and maxes and union them together and resummarize to get the total min and max in your dataset and then append that to your workflow for comparison purposes.

[viditverma62]

Hello,

I tried running this but its showing the opposite in place of maximum end date its showing minimum or vice versa.

i have attached the screenshots of Alteryx output below. 17th August date should be my maximum.

Is it causing issue may be because the date format of placement end date column in my excel file is different i have attached that too in a screenshot 2.

its showing dates as 8/10/2020 and 10-Aug-2020 in cell. Please help how should i deal with this date format in Alteryx. where is the problem lying?

just for your refrence, i selected summarize tab and for placement end date i once select min and then again max

Excel format below:

[apathetichell]

Are you converting to date/time first - and if so can you confirm that it's converting without errors? 

[viditverma62]

Hello,

i changed the date1 to date time but now its showing NULL 

i just found its showing this error :

This is the output below:

  i tried to change the placement end date data type to date and v_string as well but still not showing desired output 

[apathetichell]

Hi!,

Select can't convert to date/time or process a date/time unless it's formatted exactly correctly.

Your date1 is formatted as "Jun, 11, 2017" - this is characterized as mmm dd, YYYY (where mmm represents the 3 letter code for month).  You can either convert in a date/time tool, create a new field in formula with:

datetimeparse([date1],"%b %d, %Y")

or add a multi-field formula.

click on your field.

click to make sure you are not changing the field name

click to make sure you are changing fieldtype to date

and use the following formula

datetimeparse([_currentfield_],"%b %d, %Y")

Any of those should work. This assume all dates are formatted as 3 letter month date, full year.

[viditverma62]

Hello,

Sorry for late reply. Thanks for your help. i was able to do it with your help.

I have divided the workflow into 3 smaller workflow

when first one runs it generate one file in xlsx that gets loaded in workflow 2 and then on basis of 2nd , the final output is generated in 3rd workflow.

now i want to schedule this workflow and i have place my files on amazon s3 using s3 download n upload but i am unable to schedule it at a particular time to a particular email id. so, that the final output that gets generated should go to my client email.

pls help.

[apathetichell]

Hi! Are you using a chained app system to have one app open the next? Also -  do you get an error on trying to use the scheduler?