Skip to Content

SDI Flowgraph

Hi,

could somebody explain me, how we can select a column from the source table and look for some specific value (like '%test%';) and set a flag in the target table, if something was found.

Do I've to do it within a Filter Node or is there an other node, which I should use?

Table --> Filter --> Table

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 16, 2016 at 06:28 PM

    Hi Dirk,

    so the output should be just one row for the table that has then either the flag set or is empty?

    If so, please try this:

    Table -> Filter

    with filter expression: "Filter1_Input"."ColumnName" like '%test%'

    Remove all the output columns and add one with Datatype varchar(1)

    Add the mapping expression of this column:

    CASE WHEN COUNT(*) > 0 THEN 'Y' ELSE 'N' END

    Then connect it to your target table (or TemplateTable).

    This will now output Y in case test was found in the column and N in case it wasn't.

    Kind regards,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded