Home > Mobile >  Azure Data Factory - Add current time & random numbers
Azure Data Factory - Add current time & random numbers

Time:10-10

In Azure Data Factory, I am preparing a pipeline for some data that I could like to run. I have a dynamic content script for the output of a Copy Data activity (attached are visualised data factory and output file).

QUESTION: When I add the timezone script, why does the output file in the blob storage show random numbers at the end of the file (i.e. the "7539827")? What can I do to remove this?

Following are the scripts for the original dynamic content and the script with the date.

Original Dynamic Content script

@concat('     _',pipeline().parameters.SliceStart,"_')

Script with Timezone

@concat('Test_',convertTimeZone(utcnow(),'UTC','New Zealand Standard Time'),'_')

Images: visualised data factory , csv output in blob storage

CodePudding user response:

Try mentioning the format like this

@concat('Test_',formatDateTime(convertTimeZone(utcnow(),'UTC','New Zealand Standard Time'),'yyyy-MM-ddTHHmmss'), '.csv')

  • Related