macro to take a input file and generate output

Question

Hi all:

I need to unzip some files, do formatting, update columns and output final data. All the steps are done but instead of repeating the below steps every time I want to create a marco that will ask for input file name from user and generate output. So, the macro should have a input connector to supply file name and a output connector that will hold the output values and let user decide whether he/she wants to save in in a file or store in a db or perform join or other activities.

Never created a marco before, so need some help.

thanks

tanvir_khan · Answer

Hi @Qiu

I've configured input data tool (unzip, format etc.), I want to wrap it inside marco otherwise users need to re-configure those everytime they pick a new file which I'm trying to avoid. Isn't it possible to pick the file name only and supply to marco which will do the rest? Appreciate if you let me know if possible.

Thanks!

Qiu · Answer

@tanvir_khan 
Try to search for a Standard Macro.

The input and output are usually outside of a macro and the data processing part will be inside.