topic Re: Alteryx Designer in Alteryx Designer Desktop Discussions

Alteryx Designer

subin1234 — Wed, 20 Jun 2018 09:49:46 GMT

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

Re: Alteryx Designer

BenMoss — Wed, 20 Jun 2018 09:57:56 GMT

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

Re: Alteryx Designer

subin1234 — Wed, 20 Jun 2018 10:03:03 GMT

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.

Re: Alteryx Designer

BenMoss — Wed, 20 Jun 2018 10:18:36 GMT

What version are you using @subin1234?

Ben

Re: Alteryx Designer

subin1234 — Wed, 20 Jun 2018 11:40:54 GMT

I am using 11.05.

Re: Alteryx Designer

BenMoss — Wed, 20 Jun 2018 11:46:01 GMT

Does this work?

Ben

Re: Alteryx Designer

subin1234 — Wed, 20 Jun 2018 12:08:49 GMT

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.

Re: Alteryx Designer

BenMoss — Wed, 20 Jun 2018 12:10:20 GMT

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

Ben

Re: Alteryx Designer

subin1234 — Wed, 20 Jun 2018 13:02:58 GMT

thank you very much. Its working fine