topic Re: Replacing Field Value already loaded in QlikView

Replacing Field Value already loaded

Tue, 11 Sep 2012 15:49:54 GMT

I load data into Fact table from our ERP system and I have a field called Payer. I then Left Join to Fact data in a spreadsheet that has the fields Payer and Exclude. The Exclude field will have the value of 'Y' in it. Now the Exclude field in Fact will have a 'Y' or it will be Null.

My Question:

After I have done the above (Fact table is now loaded with Payer and Exclude fields, I want to go through a differnet logic process, something like if Payer = X and some other field = Z Change the Exclude field from Y to N. Is there a way to overwrite the value of a field?

Thanks,

Re: Replacing Field Value already loaded

hic — Tue, 11 Sep 2012 16:07:11 GMT

Don't do the join. Instead, start by loading the Payer and Exclude fields from the Excel sheet:

Load

Payer as ExcludedPayer

From Excel ...

Where Exclude = 'Y'.

Then load your fact table:

Load <all_other_fields>,

if( Exists(ExcludedPayer,Payer), // if Payer already exists in the previous table

if( Payer = 'X' and Field2 = 'Z', 'N', 'Y'),

'N' ) as Exclude

From FactTable;

... or some similar logic in the if-function.

HIC

Re: Replacing Field Value already loaded

whiteline — Tue, 11 Sep 2012 16:07:53 GMT

I think, only if you load them into another table.