Alteryx Designer

[subin1234]

Hi Guys,

I have two files as below 

testcasename

FV_001

FV_002

FV_003

FV_004

FV_005

FV_006

2nd file 

OrderNumber	TestCaseName	Status
111	FV_001	Pass
111	FV_002	Pass
111	FV_003	Pass
111	FV_004	Pass
111	FV_005	Pass
222	FV_001	Pass
222	FV_002	Pass
222	FV_003	Pass
222	FV_004	Pass
222	FV_005	Pass
333	FV_001	Pass
333	FV_002	Pass
333	FV_003	Fail
333	FV_004	Pass

I need to each testcase in file1 to go through each ordernumber and testcase in file 2 and give me an output as below.

OrderNumber	TestCaseName	Status
111	FV_001	Pass
111	FV_002	Pass
111	FV_003	Pass
111	FV_004	Pass
111	FV_005	Pass
111	FV_006	Rejected
222	FV_001	Pass
222	FV_002	Pass
222	FV_003	Pass
222	FV_004	Pass
222	FV_005	Pass
222	FV_006	Rejected
333	FV_001	Pass
333	FV_002	Pass
333	FV_003	Fail
333	FV_004	Pass
333	FV_005	Rejected
333	FV_006	Rejected

If the testcase is not present in file 2 for a particular order number then the output should have the status as rejected for that ordernumber and testcase.

Is there any way this can be done 

[BenMoss]

Hi @subin1234,

Here's how you can come to the output you desire.

The summize and append tool allows us to create an 'all possible scenarios' between order numbers and test cases. We can then use a join tool against our 2nd dataset to identify aspects from our all scenarios table that are missing, these are those that have been rejected.

Example workflow attached.

Ben

[subin1234]

Can u send the screenshot of the configuration of the tool used in the workflow. I am getting error message while trying to open the workflow.  Thanking in advance.

[BenMoss]

What version are you using @subin1234?

Ben

[subin1234]

I am using 11.05. 

[BenMoss]

Does this work?

Ben

[subin1234]

Thanks for the sample. Its working fine. But Error is throwing on appends of more than 16 Records: Is there any way to get rid of this error as I will be dealing with a lot of records.

[BenMoss · Accepted solution]

Yes, in the append fields tool, check the option at the bottom 'allow all appends'

Ben

[subin1234]

thank you very much. Its working fine