SPLIT OUTPUT BASIS COLUMN VALUES

[VJ_88]

• We have 05 Manufacturers for 03 Countries
• GERMANY - 02 , USA - 02 and JAPAN - 01

Similarly we have 08 distinct Models

• AUDI - 01 , MERCEDES - 02,TOYATO - 02, FORD - 02 and General Motors - 01
• Similarly as above each Car Model has different Year of manufacturer

In our dataset or input we have around 26 row as distinct and 04 as duplicate.

Which means it will generate only 22 PDF's but not 26.

Our requirement is to 

1. Generate a Pivot table type report output to be in  PDF from Alteryx workflow
2. Adding complexity to above point is it should generate a SEPARATE PDF for a unique rows 
3. Which means 
4. 01 PDF for row no 2 and 3
5. 2. Second PDF for row no 4
6. Third PDF for row no 5
7. .....
8. Nth PDF for row  number 27

Basically as per attached dummy data we have  22 PDF ( as 22 row as are unique and 04 rows are duplicate). this 04 duplicates will be added in 01 excel example GM  CADILLAC will have 01 PDF as these 02 rows are nt unique

Whereas FORD MUSTANG should GENRATE 02 separate PDF 01 for 1965 and another for 2024

[MelGibson]

See if this works for you 

[VJ_88]

Hi @MelGibson ,

Thank you so much for dedicating your time to solve my problem

One request I do not have Alteryx on my personal PC and on company PC we are not allowed to download

if you can share screenshot of your workflow it would be really helpful 

[VJ_88]

Hi @MelGibson ,

kindly share workflow screenshot 

[MelGibson · Accepted solution]

sorry for the delay - I don't work the weekends.