This is an automated email from the ASF dual-hosted git repository.
hansva 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 1370e04b27 Example for Action - Columns exists in a table (#5899)
1370e04b27 is described below
commit 1370e04b27cd47526486bd545aedd91a10e8ac93
Author: Drazen Sander <[email protected]>
AuthorDate: Sat Oct 25 14:46:37 2025 +0200
Example for Action - Columns exists in a table (#5899)
Co-authored-by: SANDER Drazen <[email protected]>
---
.../samples/actions/columns-exist-in-a-table.hwf | 149 +++++++++++++++++++++
1 file changed, 149 insertions(+)
diff --git
a/plugins/actions/columnsexist/src/main/samples/actions/columns-exist-in-a-table.hwf
b/plugins/actions/columnsexist/src/main/samples/actions/columns-exist-in-a-table.hwf
new file mode 100644
index 0000000000..970955049f
--- /dev/null
+++
b/plugins/actions/columnsexist/src/main/samples/actions/columns-exist-in-a-table.hwf
@@ -0,0 +1,149 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+
+-->
+<workflow>
+ <name>columns-exist-in-a-table</name>
+ <name_sync_with_filename>Y</name_sync_with_filename>
+ <description/>
+ <extended_description/>
+ <workflow_version/>
+ <created_user>-</created_user>
+ <created_date>2025/10/25 10:59:29.636</created_date>
+ <modified_user>-</modified_user>
+ <modified_date>2025/10/25 10:59:29.636</modified_date>
+ <parameters>
+ </parameters>
+ <actions>
+ <action>
+ <name>Start</name>
+ <description/>
+ <type>SPECIAL</type>
+ <attributes/>
+ <DayOfMonth>1</DayOfMonth>
+ <doNotWaitOnFirstExecution>N</doNotWaitOnFirstExecution>
+ <hour>12</hour>
+ <intervalMinutes>60</intervalMinutes>
+ <intervalSeconds>0</intervalSeconds>
+ <minutes>0</minutes>
+ <repeat>N</repeat>
+ <schedulerType>0</schedulerType>
+ <weekDay>1</weekDay>
+ <parallel>N</parallel>
+ <xloc>32</xloc>
+ <yloc>192</yloc>
+ <attributes_hac/>
+ </action>
+ <action>
+ <name>Columns exist in a table - (name, street, city)</name>
+ <description/>
+ <type>COLUMNS_EXIST</type>
+ <attributes/>
+ <connection>hop-samples</connection>
+ <fields>
+ <field>
+ <name>name</name>
+ </field>
+ <field>
+ <name>street</name>
+ </field>
+ <field>
+ <name>city</name>
+ </field>
+ </fields>
+ <schemaname>PUBLIC</schemaname>
+ <tablename>dim_sample</tablename>
+ <parallel>N</parallel>
+ <xloc>224</xloc>
+ <yloc>192</yloc>
+ <attributes_hac/>
+ </action>
+ <action>
+ <name>Columns exist in a table - (name, street, city, country)</name>
+ <description/>
+ <type>COLUMNS_EXIST</type>
+ <attributes/>
+ <connection>hop-samples</connection>
+ <fields>
+ <field>
+ <name>name</name>
+ </field>
+ <field>
+ <name>street</name>
+ </field>
+ <field>
+ <name>city</name>
+ </field>
+ <field>
+ <name>country</name>
+ </field>
+ </fields>
+ <schemaname>PUBLIC</schemaname>
+ <tablename>dim_sample</tablename>
+ <parallel>N</parallel>
+ <xloc>592</xloc>
+ <yloc>192</yloc>
+ <attributes_hac/>
+ </action>
+ </actions>
+ <hops>
+ <hop>
+ <from>Start</from>
+ <to>Columns exist in a table - (name, street, city)</to>
+ <enabled>Y</enabled>
+ <evaluation>Y</evaluation>
+ <unconditional>Y</unconditional>
+ </hop>
+ <hop>
+ <from>Columns exist in a table - (name, street, city)</from>
+ <to>Columns exist in a table - (name, street, city, country)</to>
+ <enabled>Y</enabled>
+ <evaluation>Y</evaluation>
+ <unconditional>N</unconditional>
+ </hop>
+ </hops>
+ <notepads>
+ <notepad>
+ <backgroundcolorblue>251</backgroundcolorblue>
+ <backgroundcolorgreen>232</backgroundcolorgreen>
+ <backgroundcolorred>201</backgroundcolorred>
+ <bordercolorblue>90</bordercolorblue>
+ <bordercolorgreen>58</bordercolorgreen>
+ <bordercolorred>14</bordercolorred>
+ <fontbold>N</fontbold>
+ <fontcolorblue>90</fontcolorblue>
+ <fontcolorgreen>58</fontcolorgreen>
+ <fontcolorred>14</fontcolorred>
+ <fontitalic>N</fontitalic>
+ <fontname>Segoe UI</fontname>
+ <fontsize>11</fontsize>
+ <height>150</height>
+ <xloc>0</xloc>
+ <yloc>0</yloc>
+ <note>Example:
+
+The first check verifies if the columns "name", "street", and "city" exist in
the table "dim_sample".
+Expected result: Success
+
+The second check verifies if the columns "name", "street", "city", and
"country" exist in the table "dim_sample".
+Expected result: Fail</note>
+ <width>735</width>
+ </notepad>
+ </notepads>
+ <attributes/>
+</workflow>
