I want copy all copy file naming convetion in Data pipeline

[dineshvishe1]

I want to copy A Paraquet file for all sequence.

yellow_tripdata_2025-01.parquet

yellow_tripdata_2025-02.parquet

yellow_tripdata_2025-03.parquet

yellow_tripdata_2025-04.parquet

normal for formula  for day wise.

@concat('yellow_tripdata_', variables('Copy_date'), '.parquet') 

--- ask for single day in Copy_date, i want copy all date raneg

@pipeline

[v-achippa]

Hi @dineshvishe1,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @rohit1991 and @burakkaragoz for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @dineshvishe1,

As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @dineshvishe1,

We wanted to kindly follow up to check if your issue is resolved? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[burakkaragoz]

Hi @dineshvishe1 ,

@rohit1991 's answer is spot on but missing the date range setup part. You need to feed the ForEach loop with your date list first.

Create the date range:

Simple array variable approach:

["2025-01", "2025-02", "2025-03", "2025-04"]

Then in ForEach:

@concat('yellow_tripdata_', item(), '.parquet')

Dynamic month range:

@range(1, 12)  // generates 1 through 12

ForEach expression:

@concat('yellow_tripdata_2025-', if(less(item(), 10), concat('0', string(item())), string(item())), '.parquet')

Or use addToTime for cleaner date formatting: Start with array of numbers, then:

@concat('yellow_tripdata_', formatDateTime(addToTime('2025-01-01', sub(item(), 1), 'Month'), 'yyyy-MM'), '.parquet')

The key is setting up your date array first, then using rohit's item() approach in the ForEach loop. This way you copy all months in one pipeline run instead of manually changing the date each time.

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.

[rohit1991]

Hi @dineshvishe1 

To automatically generate filenames like yellow_tripdata_2025-01.parquet in your pipeline:

• Use a ForEach activity to loop through your date list (e.g., each month).
• In the Copy Data activity's Sink dataset file name field, use an expression such as:

@concat('yellow_tripdata_', formatDateTime(item(), 'yyyy-MM'), '.parquet')

If you’re using a pipeline-level variable instead of item(), use below. This ensures each iteration writes a correctly named file based on the date.

@concat('yellow_tripdata_', formatDateTime(variables('Copy_date'), 'yyyy-MM'), '.parquet')