We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Excel tabs to PDF

Asimkz157
7 - Meteor

Hi All, 

 

I have an excel workbook with multiple tabs and I needed to convert each tab into a separate PDF.  Can anyone guide me on how to go about this without using multiple input tools for each tab?  The excel workbook has about 12 tabs but I only need 8 and convert those 8 into separate PDFs.  Thank you in advance. 

1 REPLY 1
AkimasaKajitani
17 - Castor
17 - Castor

You can use "List of Sheet Names" option at Input Data Tool when you read the Excel file.

 

AkimasaKajitani_0-1624677180169.png

 

After that, you have to make the full path of each excel sheet and then filter the sheet name and read excel file by dynamic input tool.

 

AkimasaKajitani_1-1624677527962.png

Please refer the attached workflow.

Labels
Top Solution Authors