Email a spreadsheet with multiple tabs

Was wondering if anybody has a solution to email multiple tabs in the same spreadsheet out of Alteryx Gallery?

The input data is formatted as the following:

Customer	Sheet
123456789	1
234567890	2
345678901	3
456789012	4

What I would like to do is email one spreadsheet that has all 4 sheet numbers with the Sheet number being named by the value in the Sheet column

For example:

Sheet 1 would be called 1 and have the following column

Customer

123456789

Sheet 2 would be called 2 and have the following column

Customer

234567890

Sheet 3 would be called 3 and have the following column

Customer

345678901

Sheet 4 would be called 4 and have the following column

Customer

456789012

When trying to email the file I'm only getting Sheet 1 in the results. Any help would be greatly appreciated.

Developer

Gallery

Accepted answers

alexnajm

The emailing works fine for me - the issue is your Output Data tool. You have it as Overwrite File, which is only keeping one sheet because it overwrites the file for each sheet you write out - change it to Overwrite Sheet and it works beautifully.

All comments

alexnajm

Are you referencing the file with all 4 sheets in the Email tool? It should work normally even with multiple tabs

apathetichell

The issue is - are you attaching the file or embedding it? If you are attaching it - it's just a binary. block until done/ create it. - BUD part II - attach it via blob input. -> email it.

ABCDA

I've attached a sample

workflow... For the email tool portion I am referencing the Path field as the attachment

Customer_Email_Sheet_Test_WF.yxmd

Email Tool Output.png

alexnajm

ABCDA

Awesome, thanks! That works- figured it was something simple I was missing.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703