topic Re: Load script help in QlikView

Load script help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I have a load script that contains the following:

LOAD udf_exchange_cd,
[Aggregate 1 (Positive Correlation)],
[Aggregate 2 (Negative Correlation)],
[Diminishing Balance],
[Spot Month Limit New],
[Trading Ratio New],
exchange_cd,
office_cd,
desk_cd,
formatdate,
Sum(unpriced_lots) as SumUnpricedLots,
Sum(unpriced_delta_lots*[Trading Ratio New]) as TotalAgg1,
Sum(unpriced_delta_lots*-[Trading Ratio New]) as TotalAgg2,
final_pricing_dt

The script works, however I would like to calculate the TotalAgg1 value where the pcr_num is DISTINCT. Is this possible?

Thanks,

Daniel

Re: Load script help

buzzy996 — Thu, 22 Feb 2018 15:57:40 GMT

pls share ur input values and expected output values with some sample data.

Re: Load script help

Digvijay_Singh — Thu, 22 Feb 2018 16:14:55 GMT

Maybe you do another resident load with some key fields and count(pcr_num) as another calculated field and then create another table through resident load of former table with where condtion as 'Where counted_pcr_num =1".

Inner join this 2nd table to the main table and this will keep only records where pcr_num is distinct

Re: Load script help

Peter_Cammaert — Thu, 22 Feb 2018 16:48:51 GMT

I think you better post the entire LOAD statement. There is no field pcr_num in your sample.

Re: Load script help

shiveshsingh — Thu, 22 Feb 2018 16:59:03 GMT

Where is pcr_num in your script? HOw this is related with TotalAgg1 ?