Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

how to get colour one output file against multiple input file

Asteroid

Hello

 

Please help me to find how to get 3 different output file with 3 different Input file in one excel workbook based on certain colour condition.

Example:- 
File- 1

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19Not sent12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CWIP10/29/19In Transmit10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

File 2: -

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19In Issue12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CRejected10/29/19May get Rejected10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

File 3:- 

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19In Issue12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CRejected10/29/19May get Rejected10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

One OUTPUT File Require with different tabs- 
Colour Condition as follow:-
In Transmit  -Yellow
Accepted - Green
Rejected, May get Rejected & In Issue -  Red

Rajeev18_0-1578048137985.png



 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @Rajeev18 ,

 

For that you need to use the table tool from the reporting tools. There you need to set custom rules for each column.

 

Since there are 3 possibilities you need to add 3 rules for each one.

 

After that, add a formula giving it a name to each reporting.

 

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

 

Regards

 

Edit: added a sample

Highlighted
Asteroid

Hello @afv2688 

Thank you for the reply. It is fulfilling the requirement for the shared example. However it creating some error with my existing flow chart where I wanted to implement it. 

I am sharing the full example (attaching the excel as well) which I need to be executed. Kindly look into this and let me know if it can be implemented there. As am not able to combine two different formula in one workflow. 

Thanks

Highlighted
Asteroid

Hello @afv2688 

Input file 1(Raw Data): From this file I want output file (sheet named as submitted ) with data which should includes data of 1st level Approval status of submitted one and 2nd level Approval status of submitted and completed . Means submitted output file should not include any data of rejected, WIP, In issue, Not Sent. 

Similarly From same Input File 1(Raw Data) :-  one more output file (sheet names as Accepted) with data which should includes data of 1st level Approval status of Accepted and completed one and 2nd level Approval status of Accepted and completed. 

Product IDProduct Name1st level Approval status2nd level Approval status
12345XSubmittedSubmitted
23456YSubmittedCompleted
98766ZAcceptedNot sent
45678ACompletedAccepted
32156BRejectedNo Demand
23457CWIPNot sent
45678WSubmittedIn Issue
12980XAcceptedAccepted
45987YNot sentSubmitted
345678ZAcceptedAccepted
234568QSubmittedSubmitted
245677PIn IssueWIP


Output file 1 ( Sheet named Submitted ) will looks like this: 

Product IDProduct Name1st level Approval status2nd level Approval status
12345XSubmittedSubmitted
23456YSubmittedCompleted
45987YNot RequiredSubmitted
234568QSubmittedSubmitted


 Output file 2 ( Sheet named Accepted ) will looks like this: 

Product IDProduct Name1st level Approval status2nd level Approval status
98766ZAcceptedNot sent
45678ACompletedAccepted
12980XAcceptedAccepted
345678ZAcceptedAccepted

 

Input File 2(New York): - This Input File should come exactly in same format in same output file named as New York with combination of few color formatting .
Like for status - "In transmit ' -  Yellow Colour,   "Accepted"  - Green Colour, "Rejected", "In Issue" and "May get Rejected"  - Red Color in both the approval Column.

Product IDProduct Name1st level Approval statusDate2nd level Approval statusDate
12345MIn Transmit12/13/19Submitted12/13/19
23456NIn Transmit10/19/19Submitted10/19/19
98766ZAccepted12/13/19Not sent12/13/19
45678AAccepted11/25/19Accepted11/25/19
32156BRejected12/13/19Rejected12/13/19
23457CWIP10/29/19In Transmit10/29/19
45678WSubmitted12/11/19In Transmit12/11/19
12980XAccepted12/11/19Accepted12/11/19
45987YRejected12/01/19Submitted12/01/19
345678ZMay get Rejected12/11/19Accepted12/11/19
234568QIn Issue10/27/19Submitted10/27/19
98765sAccepted12/13/19In Transmit12/13/19

 

Output File (New York) - should have this color combination: in same excel workbook under sheet named- New York

Rajeev18_1-1578372729218.png

 

 

Similarly for Input file 3 ( California) & Input File 4 ( San Francisco) - Output file should have same colour combination ( as was done for New York) in the same workbook under sheet name - California & San Francisco .

In addition to that out of the Rejected one from output file New York , California & San Francisco data , latest rejected data (latest should count should based on Current minus 1 day) i.e. if for Today's date (12/13/19) Reject for 12/12/2019  should come into one another sheet name - "Rejected status" in the same workbook.

Another requirement is that "In Transmit" product status from New York , California & San Francisco data should eliminated from submitted sheet(i.e.which was already extracted as output data sheet name - Submitted). Means submitted sheet should not contain "In transmit"  product data .


Hope I am able to make you understand what exactly I am looking for, I have attached all the file for reference .


Thank you in advance!

Regards,
Rajeev

Highlighted
Asteroid

Hello @afv2688 

Thank you for taking time and helping with the this, Could you please help me with one more thing , I have one more workflow for different condition along with the one you shared. when i am clubbing both into one i am only getting the output sheet for your workflow only not for the existing one. I want all output to be in one excel workbook. 

I have attached the complete workflow.

Please note earlier old workflow was giving output in that excel. 


Rajeev18_0-1578659372961.png


Regards,
Rajeev 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @Rajeev18 ,

 

You didn't attach any workflows.

 

To clarify, you want to have all sheets (sheet1, sheet2, sheet3) on the same workbook right?

 

Regards

Highlighted
Asteroid

Hello @afv2688 

Yes your understanding is correct . I want all the sheets (sheet1, sheet2 , sheet3, sheet4 & sheet5) in one workbook.

I have attached the image of the workflow.

Do you need alteryx workflow as attachment?

Regards, 

Highlighted
Asteroid

hello @afv2688 

Here is the attached workflow and supporting file. 


Regards,

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Nice work @Rajeev18 ,

 

You almost got it right. You need to create also tables for sheet1 and 2

 

Untitled.png

 

That would do it!

 

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

Regards

Highlighted
Asteroid

Hello @afv2688 ,

Thank you so much for your time. It was of great help, now i am able to get the desired output.

Regards,

Rajeev

Labels