Can i build a new audience with transfer file? or does the file structure need to exist first?

[mm35]

hello

i have an audience import i need to setup which will refresh each day and will wipe the data then repopulate. The audience sits on my sftp network.

In order to run this for the first time, i have used transfer file - load file, however this has errored. I assume because there is no column definition? previously i have done this via direct csv upload so im not sure the best way.

[JimXue · Accepted solution]

Hi @mm35,

Yes, you will need to define the columns in the load file so the data from the file can be loaded into the workflow temporary table. I suspect when you used the direct file load, you used the load file activity and used the automatically configured file structure and column definitions. If your existing files match that structure and column definition, you can connect your download file activity to that load file activity, just make sure to check "use the file specified in the inbound transition".

Hope this helps,

Jim