Hi all
Please, let me ask you for your help. What should I do when I want Alteryx to create a new sheet when it finds a particular value. For instance, I would need to have sheets where the access approver would be the same. so I want to have all information from the table but the access approver in one sheet would be for one person so let's say for Lucy Lucy I want to have all info: Universal ID, Instance, Data type, etc. and for each approver, I want to have a separate sheet with all these information. Could you please help me? thank you
Solved! Go to Solution.
Hey @Kate13122,
From what I understand from the question I think you will want this setup:
The output tool creates a tab for each ACCESS APPROVER.
Any questions or issues please ask :)
HTH!
Ira
Hi Ira,
thank you for your help. Yes, this is what I need, but now it shows me an error that the sheet name must be specified. Could you please advise how to have there just names of approvers? Thank you very much.
@Kate13122 Two things to check:
One, when you selected where to but the file you specified a sheet name. Two, that sheet name appears as shown in the screenshot after "|||":