data reduction help

[qlikmpate0]

Hi i'm try to retrieve all the purchase orders and requisiton for a department, I have restricted the first load which is my gl_code combination to only retrieve for the department I'm interested in and then retrieving the purchase orders for that department, but i'm getting all departments . I have attached the table joins as the data is too sensitive.

Please can anyone help?

Message was edited by: Mina Patel My Script is attached now.

[qlikmpate0]

Hi Avinash,

have you had a chance to look at my script?

regards

M

[avinashelite]

Hi Mina,

Sorry for the delayed response , can you please share it an text format ?

As per my analysis don't use the like clause in the  where condition , instead of that specific the exact department name

[qlikmpate0]

The attachment is in text format

[avinashelite]

its not in text format ...its QVS

[qlikmpate0]

attached as *.txt file as per your request.

[vardhancse]

Hi,

If we want only relevant records from the previous table use left join instead of inner join.

Mostly in your script there are inner joins

[qlikmpate0]

I have tried it with left joins and still getting the same results.

[vardhancse]

we should do left join (fact table), then automatically we can get relevant records from all other tables.

Or else use

using where condition in the script level.

[qlikmpate0]

That was my next step, I will let you know how i get on. I already have the where clauses but I was thinking of creating a fact table and see where and what results I end up with.

[avinashelite]

Hi Mina,

Your tables loading order should in the below order , please maintain the same order as below and change your script accordingly .

GLCodeCombinations:

Load *

from table;

left keep(GLCodeCombinations)

PO_Req_Distributions_All:

load

*

from

table;

Left(PO_Req_Distributions_All)

PO_REQ_Lines:

Load

*

from

table;

left keep(PO_REQ_Lines)

PO_Line_Locations:

Load *

from

table;

left keep(PO_REQ_Lines)

PO_REQ_Headers:

load

*

from

table;

left Keep (PO_Req_Distributions_All)

PO_Distributions_All:

load

*

from

table;

left keep(PO_Distributions_All)

PO_Lines:

load

*

from

tables;

left keep(PO_Lines)

PO_Headers:

load

*

from

tables;

left keep(PO_Headers)

POVendors:

load

*

from

tables;