Match output data from Alteryx to other file

[Duyen]

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 solution]

@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/...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-Templates-using-Blob-Too... 

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... 

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 solution]

Hello, @Duyen.

Is this method acceptable?

[Duyen]

Thank you guys, I didn't expect such a quick and great feedback like these!