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.
SOLVED

Workflow to handle changing dates coming from a Cross Tab tool

RajR
6 - Meteoroid

Hi,

 

Need help or guidance with a workflow I am working on where the output data is to be structured based on dates (Cflow_dt field) in the input file. I have created a test workflow using the Cross Tab and Formula tools to get the desired output. While this works fine, the issue is dates in the "Cflow_dt" in the input file change each time a new input file is provided and the workflow fails as the dates coming out of the Cross Tab into the Formula tool are hard coded (fixed based on a input file). So, each time a new input file is provided, the date fields in the "Data Cleansing" and "Formula" tools need to be manually updated for the workflow to run ok. Is there a way to make the workflow independent of the changing dates and work without having to manually update dates for each input file.

 

Below is the test workflow. Also attached are the test input file and the workflow yxmd file.

 

RajR_1-1579186138915.png

 

Input File Format - is below. The Cflow_dt in the input file will always have at least 2 or more distinct dates and these would change for each input file. There will only be one input file to the workflow for each run.

 

RajR_0-1579185843853.png

 

Cross Tab tool configuration is below

 

RajR_2-1579186219394.png        RajR_3-1579186252687.png

 

Output from Cross Tab tool is 

 

RajR_4-1579186364678.png

 Formula tool configuration is 

 

RajR_5-1579186414058.png

 

Final output data is filtered for records with GrandTotalUSD >= 10 million.

 

RajR_6-1579186536033.png

 

Any help or guidance would be much appreciated.

 

Thanks,

Raj

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @RajR ,

 

This would do it:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

RajR
6 - Meteoroid

Thanks a lot @afv268, that did the trick!

 

I just needed the output to be in the same original format (including the different Cflow_dt dates fields), so just added a Join tool to the join the output from the Transpose --> Summarize tool & Cross Tab tools as below. This is working as expected irrespective of the different dates and number of distinct dates under "Cflow_dt" field in the input file.

 

RajR_0-1579192351873.png

Labels