Excel Pivot Logic

[AS]

Hi Experts,

I'm confused in an logic. Please help me !

Expected output is below-

Number	Type	Status	Alteryx Status
404	H/D	Close	H/D Open
404		Not Started	H/D Open
404	S/D	Close	H/D Open
404		Close	H/D Open
303	H/D	Close	H/D & S/D Open
303		Not Started	H/D & S/D Open
303	S/D	Close	H/D & S/D Open
303		Not Started	H/D & S/D Open
305	H/D	Close	Close
305		Close	Close
305	S/D	Close	Close
305		Close	Close
402	H/D	Close	Open
402		Close	Open
402		(Blank)	Open
402	S/D	Close	Open
402		Close	Open

Can't have multiple comments. for the same documents.

Thanks in advance

[atcodedog05]

Hi @AS 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[AS]

The input table is contains Number, Type and Status. On the bases of Status I'm writing Alteryx Status.

Number	Type	Status	Alteryx Status
404	H/D	Close	H/D Open
404	H/D	Not Started	H/D Open
404	S/D	Close	H/D Open
404	S/D	Close	H/D Open
303	H/D	Close	H/D & S/D Open
303	H/D	Not Started	H/D & S/D Open
303	S/D	Close	H/D & S/D Open
303	S/D	Not Started	H/D & S/D Open
305	H/D	Close	Close
305	H/D	Close	Close
305	S/D	Close	Close
305	S/D	Close	Close
402	H/D	Close	Open
402	H/D	Close	Open
402	H/D	(Blank)	Open
402	S/D	Close	Open
402	S/D	Close	Open

[atcodedog05]

Hi @AS 

Here is how you can do it.

Workflow:

Hope this helps : )

[AS]

getting some unusual outputs while using contains() please help. sharing screenshots. I wrote if status !contains("Close >>",Target) then output must be open but not getting correct answer. 

[atcodedog05]

Hi @AS 

Can you try only this also dont add ,1 at the end.

!contains("Close",Target)

Hope this helps : )