How to create an identical table with restricted selected lines?

[#1]

Hello,

I have a table like this, where the Planned quantity and the Delivered quantity are expressions:

Order	Planned	Delivered
1	50	50
2	100	20
3	150	0

I would like to do another table, identical to this one, but only select the lines where the Delivered quantity = 0

For example, my new table would contain only the last line of this example:

Order	Planned	Delivered
3	150	0

How can i do this please?

Thanks,

Regards,

Loïc

[swuehl]

Add this to your LOAD script:

NOCONCATENATE LOAD

LOAD Order,

          Planned,

          Delivered

RESIDENT YourTable

WHERE Delivered = 0;

DROP TABLE YourTable;

[Anonymous]

You can take a resident of same Table like

Load

*

Resident TableName where Order='3';

Use noconcatenate as it will automatically concat it and rename the fields name as well...

You can use Qualify/Unqualify as well for renaming

[Anonymous]

What are you Planned and Delivered expressions ?

[#5]

Thanks for your reply.

I know this would work but i would prefer to do this outside of the script cause the amount of lines is huge...

[Anonymous]

Outside the script means?

if you want to use in QV, then it should be in QV...

[swuehl · Accepted solution]

If  order is your dimension then you try these two expression:

Planned:

=If( YourOriginalDeliveredExpressionComesHere = 0, YourOriginalPlannedExpressionComesHere, 0)

Delivered:

=0

and enable 'suppress zero values' on presentation tab