topic Re: Bulk Insert (Static List) for each row in Talend Studio

Bulk Insert (Static List) for each row

Anonymous — Tue, 22 Oct 2019 04:42:04 GMT

Hi,

I need to insert settings values(static list) for each product

Product List (Product_TBL) ->for each -> Static settings list -> Bulk insert (Product_settings_TBL)

Can anyone help me in this issue?

Re: Bulk Insert (Static List) for each row

Anonymous — Tue, 22 Oct 2019 05:50:23 GMT

Hi,

You can get the list of Product data and then use a tFlowtoIterate component to iterate for each record from Product table. For each iteration, extract the data and use tDBBulk component to load into target area.

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: Bulk Insert (Static List) for each row

Anonymous — Tue, 22 Oct 2019 06:08:08 GMT

Product Settings(Static List) - Each row have different values

Re: Bulk Insert (Static List) for each row

Anonymous — Thu, 24 Oct 2019 04:34:38 GMT

@soundarc

Your query seems bit vague. Could you please share 5 input records and the expected value at output section? It would be great if you can share the current job screen shot also to understand what you are getting as output.

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: Bulk Insert (Static List) for each row

Anonymous — Thu, 24 Oct 2019 05:12:42 GMT

For each product,Need to save bulk of settings values(Same Key with different values) in settings_tbl

Product_settings.png

Re: Bulk Insert (Static List) for each row

Anonymous — Thu, 24 Oct 2019 15:00:26 GMT

Hi,

Unfortunately your post do not have full data for investigation. Now I understood your input data. What is your output schema where you are trying to load data? When you are using tFlowtoIterate as mentioned in my previous post, what is the error you are getting? Could you please share your current job screenshots?

Also, when you are sharing the input data, could you please share as csv files or add sample data in the comment itself? If you are adding it as picture, we will not be able to copy and test it. Most of the community members volunteer in Talend community in between their normal daily jobs. The truth is they may not have time to recreate a sample file from screenshot unless its a very small file with 2 or 3 columns.

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: Bulk Insert (Static List) for each row

Anonymous — Fri, 25 Oct 2019 04:55:40 GMT

product_settings.xlsx