topic Re: Dynamic File name generation based upon value in Talend Studio

Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 21:21:38 GMT

Hi Guys

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

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 21:36:57 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 21:57:49 GMT

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

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 22:23:54 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 22:38:29 GMT

error on filename

12.PNG

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 22:57:54 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Wed, 22 May 2019 23:30:13 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Thu, 23 May 2019 16:05:40 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Thu, 23 May 2019 16:08:15 GMT

file name will only change once with the month attached name

Re: Dynamic File name generation based upon value

Anonymous — Thu, 23 May 2019 17:17:27 GMT

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 🙂

Re: Dynamic File name generation based upon value

Anonymous — Fri, 24 May 2019 17:11:09 GMT

where DW_DATE_ID = '" + ((BigDecimal)globalMap.get("Month"))+"'

123.PNG

Re: Dynamic File name generation based upon value

Anonymous — Fri, 24 May 2019 18:11:27 GMT

Hi,

That error is because you must be trying to load a string value (say May or March) in a numeric column. It is a DB error.

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 🙂