Copying data from2 input files using Vlookup and Hlookup to mastersheet

Question

HI All, I am new to Alteryx and was working on collating a simple day to day activity, I need to copy certain columns based on the my Master file account number. I have attached samples Master files and two input files as reference also i have color coded for the respective columns against my master file.

Could you please help me design a workflow.

MasterFile.xlsx

InputFile_1.xlsx

InputFile_2.xlsx

prveenk86kumar · Answer

@AmrMansour thanks for the response, i am unable to get this on board , could you help me out with the workflow

AmrMansour · Answer

Hi @prveenk86kumar

Hopping all is good with you.

I am not sure to perfectly understand where you are blocked but I am sure that these resources will help you to find a solution on your own 😉:

1. Find Replace Tool | Alteryx Help

2.Solved: VLookup Function - Alteryx Community

3.Solved: Alteryx Designer - Transpose / HLookup Equivalents - Alteryx Community

4.Transpose Tool | Alteryx Help

I'll be happy to go through your workflow and fix any issues.

Cheers

Amr