This is an automated email from the ASF dual-hosted git repository.

bamaer pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/hop.git


The following commit(s) were added to refs/heads/main by this push:
     new 947ecbe21e Transform pages: Samples section for Add value fields 
changing sequence to Database impact, addresses #9469 (#9493)
947ecbe21e is described below

commit 947ecbe21e681cd032841bf37c1a83af7d6bdac6
Author: Adalennis <[email protected]>
AuthorDate: Sun Nov 15 09:52:09 2026 +0100

    Transform pages: Samples section for Add value fields changing sequence to 
Database impact, addresses #9469 (#9493)
---
 .../ROOT/pages/pipeline/transforms/addfieldschangesequence.adoc   | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/binaryfileoutput.adoc  | 4 ++++
 .../ROOT/pages/pipeline/transforms/checkwebserviceavailable.adoc  | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/clonerow.adoc          | 6 +++++-
 .../modules/ROOT/pages/pipeline/transforms/closure.adoc           | 6 +++++-
 .../modules/ROOT/pages/pipeline/transforms/coalesce.adoc          | 3 +++
 .../modules/ROOT/pages/pipeline/transforms/combinationlookup.adoc | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/concatfields.adoc      | 3 +++
 .../modules/ROOT/pages/pipeline/transforms/copyrowstoresult.adoc  | 4 ++++
 .../ROOT/pages/pipeline/transforms/creditcardvalidator.adoc       | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/csvinput.adoc          | 8 ++++++++
 .../modules/ROOT/pages/pipeline/transforms/databasejoin.adoc      | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/databaselookup.adoc    | 3 +++
 .../ROOT/pages/pipeline/transforms/databasevaluevalidation.adoc   | 5 +++++
 .../modules/ROOT/pages/pipeline/transforms/datasetinput.adoc      | 4 ++++
 .../modules/ROOT/pages/pipeline/transforms/datasetoutput.adoc     | 5 +++++
 .../modules/ROOT/pages/pipeline/transforms/dbimpactinput.adoc     | 4 ++++
 17 files changed, 73 insertions(+), 2 deletions(-)

diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/addfieldschangesequence.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/addfieldschangesequence.adoc
index 80e395dc8a..1503475e73 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/addfieldschangesequence.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/addfieldschangesequence.adoc
@@ -36,3 +36,7 @@ Here are the options for the transform:
 * Increment by: the value to increase at each row in the same group
 * Init sequence if value of following fields change: you can specify a list of 
fields here.
 If a value in one or more of these fields changes compared to the previous 
rows, the sequence will be reset to the start value.
+
+== Samples
+
+The samples project has `transforms/add-value-fields-changing-sequence.hpl`: a 
Calculator divides a counter from 1 to 100 by 10, and the transform starts 
`change_counter` at 1 again each time that result changes, so every 10 rows.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/binaryfileoutput.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/binaryfileoutput.adoc
index e2bc206849..0a3bf2848a 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/binaryfileoutput.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/binaryfileoutput.adoc
@@ -54,3 +54,7 @@ TIP: Prefer this transform over 
xref:pipeline/transforms/textfileoutput.adoc[Tex
 * An empty binary value (`0` bytes) writes an empty file.
 * No character encoding is applied: bytes are written exactly as stored in the 
field.
 * Supports transform error handling so failed rows can be routed without 
stopping the pipeline.
+
+== Samples
+
+The samples project has `transforms/binary-file-output.hpl`, which loads 
`files/binary-file-output.bin` into a binary field and writes it to 
`output/binary-file-output.bin`.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/checkwebserviceavailable.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/checkwebserviceavailable.adoc
index 87a2aad6e4..d569001590 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/checkwebserviceavailable.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/checkwebserviceavailable.adoc
@@ -43,3 +43,7 @@ The value is depending on the quality of service of this URL 
and experiences.
 |Result fieldname|If it connects within the given timeout and data can be 
read, it returns 'true' as a boolean result value, otherwise 'false'
 |===
 
+== Samples
+
+The samples project has `transforms/check-if-webservice-is-available.hpl`, 
which checks `https://httpbin.org/get` for 10 generated rows and writes to the 
log whether the web service is available.
+It needs internet access.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/clonerow.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/clonerow.adoc
index 4a4a7831cc..a662a9f599 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/clonerow.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/clonerow.adoc
@@ -38,4 +38,8 @@ Note: This name has to be unique in a single pipeline.
 * N / false : this is not a cloned row, it's the original row
 * Y / true : this is a cloned row, a copy of the original row
 |Clone flag field|The name of the clone flag field
-|===
\ No newline at end of file
+|===
+
+== Samples
+
+The samples project has `transforms/clone-row-basic.hpl`, which clones each of 
5 generated rows once and adds `Flagfield` (N for the original row, Y for the 
clone) and `CopyNumber`.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/closure.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/closure.adoc
index 8d0ac30cd9..307d40d621 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/closure.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/closure.adoc
@@ -37,4 +37,8 @@ It attaches the distance (in levels) from parent to child.
 |Child ID field|The field name that contains the child ID of the parent-child 
relationship.
 |Distance field name|The name of the distance field that will be added to the 
output
 |Root is zero|Check this box if the root of the parent-child tree is not empty 
(null) but zero (0)
-|===
\ No newline at end of file
+|===
+
+== Samples
+
+The samples project has `transforms/closure-generate-calculate-distance.hpl`, 
which builds a closure table from an employee hierarchy in a Data grid: each 
manager with every employee below them and the distance between them, and each 
employee with itself at distance 0.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/coalesce.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/coalesce.adoc
index 6c30fb8a3e..e9a7d3ce15 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/coalesce.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/coalesce.adoc
@@ -47,3 +47,6 @@ Pick a list of fields to evaluate and specify a field name 
and type for the fiel
 |Input fields|The order of the input fields listed in the columns determines 
the order in which they are evaluated.
 |===
 
+== Samples
+
+The samples project has `transforms/coalesce-basic.hpl`, which puts the first 
non-null value of `desc1` and `desc2` in a new field `desc`.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/combinationlookup.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/combinationlookup.adoc
index 72f498ca47..4c1b820879 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/combinationlookup.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/combinationlookup.adoc
@@ -86,3 +86,7 @@ The value is written once only because any change results in 
a new record being
 |Get Fields button|Fills in all the available fields on the input stream, 
except for the keys you specified.
 |SQL button|Generates the SQL to build the dimension and allows you to execute 
this SQL.
 |===
+
+== Samples
+
+The samples project has `transforms/combination-lookup-update.hpl`, which 
looks up the technical key of the colors red, green and blue in the `colors` 
table of the `hop-samples` connection, and inserts the colors that are not 
there yet.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/concatfields.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/concatfields.adoc
index 0c2ade251e..7a4e8915c6 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/concatfields.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/concatfields.adoc
@@ -81,3 +81,6 @@ So instead of save 0000001, we write 1, etc.
 String fields will no longer be padded to their specified length.
 |===
 
+== Samples
+
+The samples project has `transforms/concat-fields-basic.hpl`, which joins four 
fields into `1;two;3;four`, once keeping the source fields and once removing 
them.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/copyrowstoresult.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/copyrowstoresult.adoc
index bee578d953..7346d12917 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/copyrowstoresult.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/copyrowstoresult.adoc
@@ -38,3 +38,7 @@ NOTE: this transform is mainly available for historical 
reasons. There are newer
 |Option|Description
 |Transform name|Name of the transform this name has to be unique in a single 
pipeline.
 |===
+
+== Samples
+
+The samples project has `transforms/copy-rows-to-result.hpl`, which copies the 
two rows of a Data grid to the result of the pipeline, for a parent workflow or 
pipeline to pick up.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/creditcardvalidator.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/creditcardvalidator.adoc
index 5be35e9dc7..b0098f7eeb 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/creditcardvalidator.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/creditcardvalidator.adoc
@@ -70,3 +70,7 @@ NOTE: Only the BIN column is required in the CSV. The card 
type, issuer and coun
 NOTE: BIN values are limited to 8 digits. Rows whose BIN is empty, longer than 
8 digits, or non-numeric are skipped, and the number of skipped rows is logged 
when the transform initializes.
 
 NOTE: When you uncheck *Header row present* while header-based column mappings 
(the *BIN CSV Column* or any extra output *CSV column*) are still configured, 
you are prompted to confirm. Confirming clears those mappings and switches to 
fixed-position mapping; cancelling keeps the header mode and its mappings.
+
+== Samples
+
+The samples project has `transforms/credit-card-validator.hpl`, which 
validates 20 Mastercard and Visa numbers and writes the 19 valid ones and the 
invalid one to the log.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/csvinput.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/csvinput.adoc
index e0f9dccb38..07a3929b2d 100644
--- a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/csvinput.adoc
+++ b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/csvinput.adoc
@@ -72,3 +72,11 @@ WARNING: For technical reasons, parallel reading of CSV 
files is only supported
 |Get Fields button|Click to return a list of fields from the target file based 
on the current settings (i.e. Delimiter, Enclosure, etc.).
 All fields identified will be added to the Fields Table.
 |===
+
+== Samples
+
+The samples project has:
+
+* `transforms/csvinput-basic.hpl`, which reads `files/books-tiny-file.csv` and 
adds a row number.
+Run `transforms/textfileoutput-tiny-file.hpl` first: it creates that file.
+* `workflows/write-read-huge-file.hwf`, which writes a file of 25 million rows 
with `workflows/textfileoutput-huge-file.hpl` and reads it back with 
`workflows/csvinput-huge-file.hpl`: CSV input with 4 copies and parallel 
reading.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasejoin.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasejoin.adoc
index c2c61294c2..820b92ccab 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasejoin.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasejoin.adoc
@@ -89,3 +89,7 @@ See Launching several copies of a transform.
 |Parameters table|Specify the fields containing parameters.
 The parameter type is required.
 |===
+
+== Samples
+
+The samples project has `transforms/databasejoin-basic.hpl`, which gets the 
`description` of ids 1 to 5 with a query on the `dblookup` table of the 
`hop-samples` connection.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databaselookup.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databaselookup.adoc
index 2b6004b558..6b30a65a33 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databaselookup.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databaselookup.adoc
@@ -90,3 +90,6 @@ Note that this problem does not occur when using the cache, 
if "load all data fr
 Indeed, the first lookup for 'ab' would find no entry in the cache, call the 
database (which is smart enough to handle the trailing whitespace problem), get 
the correct result, and store it in the java cache under the 'ab' key.
 Thus, the next lookup for 'ab' will find the appropriate result in the cache :)
 
+== Samples
+
+The samples project has `transforms/databaselookup.hpl`, which looks up the 
description of ids 1 to 10 in the `DBLOOKUP` table of the `hop-samples` 
connection.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasevaluevalidation.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasevaluevalidation.adoc
index d8c80694d1..0e374a0ce9 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasevaluevalidation.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/databasevaluevalidation.adoc
@@ -84,3 +84,8 @@ At the end of the stream the transform logs how many rows 
were checked, how many
 * Table metadata is loaded once at start. After that the transform does not 
talk to the database.
 * An empty mapping matches incoming field names to table columns by name 
(case-insensitive).
 * If there is no error hop, the first bad row fails the transform, but the 
message still lists every failing field on that row.
+
+== Samples
+
+The samples project has `transforms/databasevaluevalidation-basic.hpl`, a 
template: set the connection and the table in the transform and map the fields.
+Two Dummy transforms stand in for a Table output and for the reject output on 
the error hop.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetinput.adoc 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetinput.adoc
index 49819c7455..4eecffae7e 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetinput.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetinput.adoc
@@ -32,3 +32,7 @@ The Data set input transform allows you to read from a data 
set in a pipeline.
 |Transform name|The name of this transform
 |Data Set Name|The name of the data set to read from
 |===
+
+== Samples
+
+The samples project has `transforms/dataset-input.hpl`, which reads the two 
rows of the unit test data set `run-pipeline-tests-input`.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetoutput.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetoutput.adoc
index ddf6d2aee8..bd210df767 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetoutput.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/datasetoutput.adoc
@@ -47,3 +47,8 @@ Rows are passed through unchanged so you can keep using the 
stream after the wri
 * Multiple copies of this transform are not supported.
 * (Re)create takes precedence over validate.
 * The GUI context actions *Create data set* and *Write rows to data set* 
remain available for interactive use on the pipeline canvas.
+
+== Samples
+
+The samples project has `transforms/dataset-output.hpl`, which writes two rows 
from a Data grid to the unit test data set `dataset-output`.
+The first run creates the data set and its CSV file.
diff --git 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/dbimpactinput.adoc
 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/dbimpactinput.adoc
index 477febea5b..a5bcb8b146 100644
--- 
a/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/dbimpactinput.adoc
+++ 
b/docs/hop-user-manual/modules/ROOT/pages/pipeline/transforms/dbimpactinput.adoc
@@ -62,3 +62,7 @@ TIP: You can use a 
xref:pipeline/transforms/getfilenames.adoc[Get File Names] tr
 |Remark|String
 
 |===
+
+== Samples
+
+The samples project has `transforms/database-impact.hpl`, which lists the 
database impact of `transforms/tableoutput-basic.hpl`: a truncate of the 
`tableoutput_basic` table and a write for each of its four fields.

Reply via email to