using dynamic input to append two different files

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

pic1.PNG

Dynamic Processing

Accepted answers

edwin_melo

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.

All comments

edwin_melo

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703