Deleting Rows when TableView Filter is true

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

BMWTouring

Intermediate

Posts: 9

Date of registration: Apr 1st 2012

Location: Netherlands

Sunday, May 13th 2012, 9:23am

Deleting Rows when TableView Filter is true

I want to delete a row from my Normalized TableTransform. Now I can throw a filter on a cell with a TableView, but this clears only the cell. But when the filter is true than is has to delete the whole row (and containing rows on the primary key)

Example:

Art number Store Type Value
1 001 wheel 100
1 001 muffler 20
1 001 engine

Engine is empty.....now it has to delete all the rows in TableTransform with Art number 1 and Store 001

Looks like I have to do it with my Select Query in Extracts. But then I cannot filter if two elements are empty...

Example:
Art number Store Type Value
1 001 wheel 100
1 001 muffler 20
1 001 engine

2 001 wheel 100
2 001 muffler
2 001 engine 300

Here is muffler empty

SELECT * FROM "Source" WHERE "muffler"<>'' OR "engine"<>''

Then I want both rows to dissapear, but only one goes...

This post has been edited 1 times, last edit by "BMWTouring" (May 13th 2012, 9:38am)