Convert Row data into column and apply Boolean.

[SakshiL]

Hi Team,

I am new to the Alteryx world. I am stuck with a problem , it would be really great if you can provide some pointers on this.

I need to create a work flow to get data in a particular format. Below is the requirement.

Check the column Product for each row.  If column code has the value then create new column for all products and if that column code has product P1 then Y if no Product in column then N.

Actual Data

Country	City	Code	Product
Australia	Perth	A123	P1
Australia	Perth	A123	P2
Australia	Perth	A123	P3
India	Mumbai	B123	P2
India	Mumbai	B123	P3
US	New York	C123	P1
US	New York	C123	P3

final data should like below.

country	City	code	P1	P2	P3
Australia	Perth	A123	Y	Y	Y
India	Mumbai	B123	N	Y	Y
US	New York	C123	Y	N	Y

[Bren_Spill · Accepted solution]

Hi @SakshiL - see solution attached

[usmanbashir · Accepted solution]

@SakshiL -

I provided two options to generate your output. Hope this helps!

 

[binuacs · Accepted solution]

@SakshiL Another method

[SakshiL]

Thank you all!

Worked like a charm. 

[Bren_Spill]

@SakshiL - Great! Can you mark the answers as solutions? You can do all three!