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