using dynamic input to append two different files

[Rive11115]

Hi,

I'm using two files via sftp.  They both align on the same column names, but File 2 has an extra field which sometimes is empty field.

Because of the extra field my dynamic input is skipping the second file (File 1).   In this case File 2 is received prior to File 1 but this could change. 

Is there a way to union the files prior to the dynamic input?

I've included a pic of the tools I'm using in the workflow.  

File 1:

ACCOUNT	SITE	TID
23	y	2
34	y	5

File2:

ACCOUNT	SITE	TID	MBUSNAME
56	u	8
78	u	9

Expected Result:

ACCOUNT	SITE	TID	MBUSNAME
23	y	2
34	y	5
56	u	8
78	u	9

[edwin_melo · Accepted solution]

Yes, you have opportunities to use the Union Tool somewhere in your workflow.  Also, looking at the picture of the tools you are using, I would recommend including the Record ID and Multi-Row Formula tools in your workflow.  The Multi-Row Formula can be used to group by FileName and create an ordinal to include the empty field.

[alexnajm]

You can also use a batch macro to overcome this - there is a description and an example here: The Ultimate Input Data Flowchart (alteryx.com)

[Rive11115]

Could you please show me how u would do this in a workflow.