You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by Md Sahabaj Ansari <Sa...@helm360.com> on 2023/04/18 06:20:29 UTC
How to replace Parameter with ? question mark
Hi,
Greetings of the day !!
My question is how I replace question mark (?) value with arguments in Execute Sql scrpt. My value is Green here.
[cid:image001.png@01D971EB.DEC9CA40]
Thanks,
Md Sahabaj Ansari
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
Re: [EXTERNAL] Re: How to replace Parameter with ? question mark
Posted by Bart Maertens <ba...@apache.org>.
Hi Md Sahabaj Ansari,
The execution information perspective[1] and corresponding metadata types
allow you to keep all of the executions in a project.
This post provides some more details on how to configure it all (thanks for
the reminder to make sure the contents of that post end up in the docs).
[1]
https://hop.apache.org//manual/latest/hop-gui/perspective-execution-information.html
[2]
https://www.leanwithdata.com/blog/apache-hop-execution-information-logging
Regards,
Bart
On Tue, Apr 18, 2023 at 9:52 AM Md Sahabaj Ansari <Sa...@helm360.com>
wrote:
> Thanks Hans !!
>
>
> it works . could you also let me know to capture the logging info in txt
> file . when I run a pipeline it save the logging in hopgui.log under audit
> folder and when I close it also erased . I want to save the logging for
> every pipeline in separate txt file .
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows
>
>
>
> *From: *Hans Van Akelyen <ha...@gmail.com>
> *Sent: *18 April 2023 01:02 PM
> *To: *Md Sahabaj Ansari <Sa...@helm360.com>; users@hop.apache.org
> *Subject: *[EXTERNAL] Re: How to replace Parameter with ? question mark
>
>
>
> Hi,
>
>
>
> The Execute SQL script is a row processing transform, it requires input
> rows to work.
>
> The values used to replace the ? Need to come from a field in the stream.
>
>
>
> The simplest way to make your example work is to add a Data Grid transform
> [1] to the canvas, in the Meta tab create a field named “colour” (type
> string).
>
> In the Data tab you can then add the value “Green”.
>
>
>
> Then you can use this “colour” field in the Execute SQL Script transform
> (where you now have written Green).
>
>
>
> Hope this helps,
>
>
>
> Hans
>
>
>
>
>
>
>
> [1]
> https://hop.apache.org//manual/latest/pipeline/transforms/datagrid.html
> <https://hop.apache.org/manual/latest/pipeline/transforms/datagrid.html>
>
>
>
> On 18 April 2023 at 08:20:41, Md Sahabaj Ansari (sansari@helm360.com)
> wrote:
>
> Hi,
>
> Greetings of the day !!
>
>
>
> My question is how I replace question mark (?) value with arguments in
> Execute Sql scrpt. My value is Green here.
>
>
>
> Thanks,
>
> Md Sahabaj Ansari
>
>
>
>
>
> Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for
> Windows
>
>
>
>
>
RE: [EXTERNAL] Re: How to replace Parameter with ? question mark
Posted by Md Sahabaj Ansari <Sa...@helm360.com>.
Thanks Hans !!
it works . could you also let me know to capture the logging info in txt file . when I run a pipeline it save the logging in hopgui.log under audit folder and when I close it also erased . I want to save the logging for every pipeline in separate txt file .
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
From: Hans Van Akelyen<ma...@gmail.com>
Sent: 18 April 2023 01:02 PM
To: Md Sahabaj Ansari<ma...@helm360.com>; users@hop.apache.org<ma...@hop.apache.org>
Subject: [EXTERNAL] Re: How to replace Parameter with ? question mark
Hi,
The Execute SQL script is a row processing transform, it requires input rows to work.
The values used to replace the ? Need to come from a field in the stream.
The simplest way to make your example work is to add a Data Grid transform [1] to the canvas, in the Meta tab create a field named “colour” (type string).
In the Data tab you can then add the value “Green”.
Then you can use this “colour” field in the Execute SQL Script transform (where you now have written Green).
Hope this helps,
Hans
[1] https://hop.apache.org//manual/latest/pipeline/transforms/datagrid.html<https://hop.apache.org/manual/latest/pipeline/transforms/datagrid.html>
On 18 April 2023 at 08:20:41, Md Sahabaj Ansari (sansari@helm360.com<ma...@helm360.com>) wrote:
Hi,
Greetings of the day !!
My question is how I replace question mark (?) value with arguments in Execute Sql scrpt. My value is Green here.
[cid:image001.png@01D971F8.5A2BAC60]
Thanks,
Md Sahabaj Ansari
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows
Re: How to replace Parameter with ? question mark
Posted by Hans Van Akelyen <ha...@gmail.com>.
Hi,
The Execute SQL script is a row processing transform, it requires input
rows to work.
The values used to replace the ? Need to come from a field in the stream.
The simplest way to make your example work is to add a Data Grid transform
[1] to the canvas, in the Meta tab create a field named “colour” (type
string).
In the Data tab you can then add the value “Green”.
Then you can use this “colour” field in the Execute SQL Script transform
(where you now have written Green).
Hope this helps,
Hans
[1] https://hop.apache.org//manual/latest/pipeline/transforms/datagrid.html
On 18 April 2023 at 08:20:41, Md Sahabaj Ansari (sansari@helm360.com) wrote:
Hi,
Greetings of the day !!
My question is how I replace question mark (?) value with arguments in
Execute Sql scrpt. My value is Green here.
Thanks,
Md Sahabaj Ansari
Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows