Limit dimension values inside Load script using Inline Table

[#1]

Hi,

I am trying to create an inline table (TESTTABLE) that will have select sales order values from table Delivery, field VGBEL. The table will also have a new field column named exclusion. I am trying to do this inside the load script, but whenever I reload the script and create the inline table, I end up with all 8,000 sales orders rather than the select few that I wanted. The other issue is that the sales orders inside my new table are not connecting to field VGBEL inside the delivery table.

Dimension:VGBEL

Table: Delivery

Below is my code

UNQUALIFY*;

TESTTABLE:

LOAD * INLINE [

     VGBEL,Exclusion

     801543678, X

     801564593, X

     ];

QUALIFY*;

[vinieme12]

This way you are only limiting rows shown in that particular tablebox not your QVW!

[rahulpawarb]

Hello Omar,

Thank you for considering my suggestion.

If you want to use JOIN or KEEP to get only two records from TESTTABLE table then you have to have INNER JOIN/RIGHT JOIN/INNER KEEP/RIGHT KEEP options by selecting TESTTABLE table in right side (for RIGHT KEEP/RIGHT JOIN). This will lead to filtration of records in the Delivery table. In this case Delivery table will only contain 2 records which are there in TESTTABLE table. Other records won't be available in Qlik. If this doesn't impact on your solution then go ahead and implement the JOIN/KEEP else go ahead natural JOIN option (stated in my prior comments).

Hope this makes sense.

Regards!

Rahul