Parameters SQL query and get the result

[Anonymous]

Hello, I want to create a database containing fields from a file and add an attribute generated from a SQL query. The problem is that this same query contains conditions like:

where column1 = '"+ (String) globalMap.get (" row1.aa ") +"

I can not retrieve the result of the request and I want to get an idea about the job components

[Anonymous]

Hi,

    Unfortunately I was not able to understand your use case.

    Could you please add more screenshots of your overall job flow along with the input and output details in a sample 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]

I have an input, I will recover the data of this input because I need it to complete the query sql from tDBRow

example:

"select TOP 1 gl_dpr from piece inner join line on a = b where gl_codea = '"+ (String) globalMap.get (" row1.Code_Article ")"

I want to retrieve the result of the request to insert it into a table

Cordially

[Anonymous]

Hi,

    Could you please share the job screen shot for better understanding and the component screenshot where you are getting error?

     All I understood now is that you have an input and you would like to do something with that input data to a tDBRow. Unfortunately it is bit vague to provide a solution.

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,

    Thanks for the details and it helped to understand your job flow better. The screenshot says that you are getting data from mvt_ods properly (138 records). First step is to add a tLogrow in between mvt_ods and tFlowtoIterate. This will make sure that you are getting data from first table properly.

    If you are happy with the data (make sure that data is in correct case and trim the data to remove any extra spaces.

     In the next stage, query the table only with first part of Where clause ( I mean equal to "ff" part). See whether data is coming properly when you are adding only this condition. Add each condition one at a time and repeat the test and data should be still coming. Also double check the DB directly by querying and seeing that the data is present in the table. 

      I feel that the data is present but there is some extra extra space in one of the column or one of the column is not matching with your condition. If you are following step by step method of adding columns one at a time, you will get the problematic 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 🙂