Output to tab in google sheet based on column

[cearles]

Hello,

If I have the following data:

EMPLOYEE NAME	EMPLOYEE ID	BUSINESS UNIT	TRAINING TITLE	TRAINING SCORE
Employee One	0001	BU_INT	Required Training FY23	90
Employee Two	0002	BU_EXT	Required Training FY23	89
Employee Three	0003	BU_INT	Required Training FY23	64
Employee Four	0004	BU_UNI	Required Training FY23	99
Employee Five	0005	BU_PROV	Required Training FY23	100
Employee Six	0006	BU_PD	Required Training FY23	87
Employee Seven	0007	BU_PROV	Required Training FY23	78

What I would like to do is write all of this to a single google sheet, but break it up so that each business unit has it's own tab in the sheet.

Currently, I separate all the BU's with filters, and then write each BU to the sheet individually.

This works, but it can be fairly tedious to setup for workflows like this, especially since we have well over 30 business units.

Sorry if this is a repeat, I searched the discussions for quite a while and found a ton of ways to do this as .xlsx, but I need to to be google sheets unfortunately.

Thank you!

[apathetichell]

yes. you'd need to use a batch macro and edit the DataRangSheetName - value in the gdrive output tool via action.

[cearles]

Thank you!

I will focus on those tools and see what I can learn.

[Qiu · Accepted solution]

@cearles 
I did not try to export to GSheet before, so I gave a try and it works.
Some notes below hope can help.

[cearles]

Thank you!

I was unable to get my google drive output tool to work, but I found a way to do it with the google sheets output tool.

The error was unrelated to your example, my Alteryx tool would not connect to google is all.

Your example gave me what I needed to figure it out!

[Qiu]

@cearles 
Good to know it works out for your either way.