Skip to Content
0

SDI Flowgraph

Nov 15, 2016 at 04:58 PM

209

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Timo Wagner
Nov 16, 2016 at 06:28 PM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Timo,

thanks a lot for your fast reply.

The requirement has changed, because I couldn't try it. But I'll keep this solution in mind!

Thanks!!!

0