Dynamic File name generation based upon value

[Anonymous]

Hi Guys

I am trying to change my file name based upon column value in my query, can you please help

[Anonymous]

Hi,

     You are having 17 records in your output. So I assume you want to load the data to 17 files.

For that, use the below flow.

But if you want to load all 17 records to a single file name, its very easy. Load the file name to a context variable in one of the early steps. Then in the file name column, use context variable.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

i want only one file but name change based upon col value, below are the shots ...i am getting error in trow generator

thanks for help

flow.PNG
generator.PNG
tmap.PNG

[Anonymous]

Hi,

     You are telling that it will be one file for 17 records. In that case, the assumption is that column used to create file name will be static for all 17 records. Based on this assumption, you can create a simpler data flow.

This flow should be able to cater your demand.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

error on filename

12.PNG

[Anonymous]

Hi,

    Apologies as I was overexcited and made a mistake. You will have to make minor change as shown below (by using buffer components in between).

newly created file

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

tgenerator will not work as this will not create correct number of rows...do you know ho to do it with tset global var

---

@nthampi wrote:

Hi,

    Apologies as I was overexcited and made a mistake. You will have to make minor change as shown below (by using buffer components in between).

newly created file

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

---

[Anonymous]

Hi,

   Could you please share whether your use case is simple as shown in my above post or whether the file name will change for each record?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

file name will only change once with the month attached name

[Anonymous]

Ok. In that case, the above method shown in my earlier post should work for you.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂