Copying data from one sheet to another.

Question

Hi all,

I am looking for a way out where we can copy data from Sheet 1 to Sheet 2. Sheet 2 has a standard template and I want to copy some of the data from Sheet 1 to sheet 2. 
A filter has been applied on Sheet 1 and on the basis of that we need to copy data from sheet 1 to sheet 2.

I have attached a file for your reference. Looking forward for a workflow. Workflow Designer Cloud

Raw file.xlsx

binu_acs · Answer

@Surabhig I think using Blob tool would be the better option in this use case

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

Nick-C · Answer

Hi @Surabhig
I've attached a workflow that should help, it uses a union tool to combine the sheets!

If this helps then don't forget to accept it as a solution so other users can find this if they run into the same challenge

Workflow for Surabhig.yxmd