Bulk Insert (Static List) for each row

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

@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

[Anonymous]

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

Product_settings.png

[Anonymous]

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

[Anonymous]

product_settings.xlsx