Alteryx Designer 2023.2.1.7-How to split an Excel sheet based on the same cell values

[PatrickD2705]

Hi @ all, 

I started using Alteryx Designer yesterday. The aim is to replace our current mobile phone billing with Alteryx. I am currently facing the problem of separating an Excel list with several phone numbers and the services used per user.

As an example: 

Mobile Number	Service	Start	Duration
+4911111111	SMS	01.10.2023	-
+4911111111	Call	01.10.2023	30 minutes
+4911111112	Call	01.10.2023	30 minutes
+4911111113	SMS	01.10.2023	30 minutes

And Now I want 3 separated Excel Sheets for each services.

Sheet 1: +4911111111

Sheet 2:  +4911111112

Sheet 3: +4911111113

How is it possible to implement this?

[CoG]

The Output Tool should be able to handle this with ease! Here is a relevant article

https://knowledge.alteryx.com/index/s/article/Output-to-multiple-sheets-within-an-Excel-file-1583459...

[binuacs]

@PatrickD2705 the below settings in the output tool should work for your usecase