Suppose a manufacturer informs you about the categories of products that will no longer be available. You don't want to have those products in your database that you will not sell. So you use PDI to delete them.
Open the
LUX_discontinued.txt
file available in the code bundle.Create a new transformation.
With a Text file input step, read the file. As Number of header lines, type
4
. Add a single field of typeString
and name itcategory
.Preview the file. You will see the following:
After the Text file input step, add an Add constants step to add a
String
constant namedman_code
with valueLUX
.Expand the Output category of steps and drag a Delete step to the canvas.
Create a hop from the Add constants step to the Delete step.
Double-click on the Delete step. As Connection, select
js
. As Target table, browse and select products. In the grid, add the conditionsman_code = man_code
andpro_theme LIKE category
. After the Delete step, add a Write...