Data Flow

[PowerRocky12]

Hello,

I am trying to create a data flow. I am pulling in data from a shared foldr with 8 CSV files included. When I bring in the folder into the data flow it is showing it as one table. I don't want to create a seperate data flow for each file... How would I create one data? Would it be possible to use my main file in the data flow and left join all the other files?

[collinq]

Hi @PowerRocky12 ,

So, this is working as designed.  You are briging all the files from the shared folder into one file by using the folder connection.  This connection is appending them all together for you.  I am not sure why you would want to do them separately and then manually append them yourself?

But, yes, you can do the exact same steps manually if you don't want the system to do it.  But, that takes longer, adds performance overhead and means more manual administration over time.  That said, if you want to do it manually, just open your dataflow, get each file individually, append them together and then turn off the enable load function on all of the individual files that you just appended together.