UPDATE / replace FIELD

[ilanbaruch]

Hi all,

I have 2 tables in my model,

the first one holds sales data (with [agent id]) and the second holds agents details.

in the sales table I want  to omit value of [agent id] if the invoice canceled with null or zero_value so the sale amount will not be connected to agent.

is that possible?

[sinanozdemir]

Yes, you can accomplish this by adding a WHERE clause in your load script:

Sales:

LOAD

     *

FROM Your_Source

WHERE Not IsNull(Sale_Amount) OR Sale_Amount <> 0;

Hope this helps.

[Peter_Cammaert]

Yes, that's possible.

You're talking about Sales information and agent details, but not about invoices and where they reside. You should merge invoice information into the Sales table, or create a mapping table that translates a sales ID into an invoice amount. That way you can filter out or reset Sales data that didn't lead to a non-zero invoice amount.

Peter