Match output data from Alteryx to other file

Question

Hi Community!

I need your help to solve this problem.

I have a output file from Alteryx, and I want to match columns of output file to another file, is there any better way than using V-lookup?

The final file I need contains formula in the first few columns so I cannot create the entire file from Alteryx.

Thank you for your help!

messi007 · Accepted Answer

@Duyen,

Please take a look on those posts :

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

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-Templates-using-Blob-Tool/td-p/1047543

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-do-I-output-to-an-Excel-template-file/ta-p/1244/jump-to/first-unread-message

You can use a template file that contains the formula and the excel formating and then use Alteryx to inject data on a specific rang of data.

Hope this helps !

Regards

acarter881 · Accepted Answer

Hello, @Duyen.

Is this method acceptable?