Data flow blob json sink destination path problem

Question

Hi!

My data flow is pretty simple:

1. source -> blob file full of JSON objects
2. derivative column -> to add fileName column to every item
3. sink -> inline blob JSON that saves every item to a separate file by column "fileName"

This is my sink setup:

As you can see the path is based on a "destination" parameter. Unfortunately, when I run this data flow, all files are placed in the container root as well as an empty file named by the "destination" parameter.

Is this a bug, or am I doing something wrong? The empty file is not a problem, but why all files are not placed in the destination folder?

Answer 1

Hi @Jan Porowski ,

Thanks for posting your query on MS Q&A portal.

You can try concatenate the whole folder path in the derived column transformation where you are forming the file name, like below -

@markus.bohland@hotmail.de ('qatemp/',$detination,'/',<filenamelogic>)

this should derive to a string with the whole folderpath plus filename.

Please try this and let us know how it goes.

thanks