Summarize Date coming back as Nulls

[Karl_Spratt]

Hi Community,

I'm trying to create a pivot view in Alteryx  but in the Summarize tool the Date coming back as Nulls

I have created this formula to add a column to change the created date into a Monthly date  formula is:

Datetimeformat([Created date], '%B-%Y')

Attaching pictures of what Im seeing ca some explain the issue please.

TIA,

Karl. 

[atcodedog05]

Hi @Karl_Spratt 

Please change the highlighted datatype to v_string. Alteryx supports date only if its in yyyy-mm-dd format all others would-be string.

Hope this helps : )

[Karl_Spratt]

Hi Atcodedog05,

When I create the date into a MMM-YYYY (V-String) later in the flow my pivot table is coming in alphabetical order, not in Month-YY Sort (like it would in excel ( Jan-20 to Oc-21) say.

How can I create the Pivot view in date sort now if i have to create a v-string column.

Any help is appreciated.

Cheers,

Karl.  

[atcodedog05]

Hi @Karl_Spratt 

Can you provide me sample data in excel I can help you out with an example. Provide me data before the conversion of date.

[Karl_Spratt]

Hi atcodedog05,

Please see attached sample imput files, and the WF I'm creating, I need to create 2 Pivot output sheets for

Created Date = Order-Entry_Mth-Yr

Requested Date = CRD-Mth-Yr

And all the line level data in a 3rd sheet ( SAP Data)

Cheers,
Karl. 

[atcodedog05]

Hi @Karl_Spratt 

You can approach it like in the below workflow.

Workflow:

Hope this helps : )

[Karl_Spratt]

Hi Atcodedog05,

Last Question, how in the pivot view can I exclude the NO Frame Items, in excel pivot I'd just uncheck this data source.

I tried adding a select tool before / after the dynamic rename tool but I don't see the vale No Frame to exclude.  

Cheers,

Karl. 

[atcodedog05 · Accepted solution]

Hi @Karl_Spratt 

Use a filter tool and filter the row out like below.

Workflow:

Hope this helps : )

[Karl_Spratt]

Thanks atcodedog05 I will accept the as a solution.

I really appreciate your help here.

Regards,

Karl. 

[atcodedog05]

Happy to help : ) @Karl_Spratt 

Cheers and have a nice day!