Jan Picht Vision Office Technical Services PLC Senior Technical Consultant

Hello Simon,

Thanks for the info! However, is there not a way to transfer the table lines to another table field and apply a filter or match code (Quantity >=0.0001) to the transfer in a Data Assignment step?

Any "outside of the box" solution would be great, too... I am thinking about using Autoindex to transfer the table lines to a temp. cabinet and then import them from there into a separate table field omitting the unwanted lines... But that would mean a lot of configuration and potential timing issues if Autoindex is not triggered quickly enough, etc...

Thanks again for any ideas!

Jan

Hello,

I have a table field with line items of delivery notes. Somehow I need to be able to remove lines from the table field where the "Quantity" (one of the columns, decimal, 4 decimal digits) contains "0.0000"

The table field looks somewhat like this at the beginning:

Sys Line No	Quote Line No	Product Code	Quantity
1	3	Prod123	12.0000
2	2	Prod234	0.0000
3	1	Prod345	10.0000

After removing the unwanted line I would expect this:

Sys Line No	Quote Line No	Product Code	Quantity
1	3	Prod123	12.0000
2	1	Prod345	10.0000

Any help is greatly appreciated!

Thanks!

Jan