Adding Macro to pick new file

[kauser]

Hello, 

 i am working in a workflow where business need to add new file (e.g. loan or funding) depends on the client. how can i build a Macro to pick those new upcoming file so Alteryx can pick those new files without modify and/or update existing workflow. 

Thank you 

kauser 

[EKasminsky]

I mean what comes to mind is doing using a directory tool, then sort by create date/last updated date, then select records tool (set as 1) to get the most recent file. 

From there, I would use a formula tool to pull the full file path, and the "Batch import multiple files" macro I found in the Gallery.

Basically, it sounds like you want to pull the most recent file to determine what to do with it, and that's how I would do it.

[kauser]

@EKasminsky 

thanks for your reply. actually i need to rephrase my question. i would like to know how to build a macro to pick new data from existing input file. such as my current input file is like below 

current month input file

item	type	color	amount
A	2	Yellow	20
C	4	green	45
D	5	orange	345
B	1	black	758

future input file when there are new item added into table (item R and Y added into this table)

item	type	color	amount
A	2	Yellow	20
C	4	green	45
D	5	orange	345
B	1	black	758
R	3	Blue	5859
Y	9	white	25