Populating a column with Non-associated values

Thu, 06 Dec 2012 02:31:46 GMT

Hi,

I have a field "Account" that has a value, "999", that is associated to only one value "555" in another Field "Account Unit".

The "Account Unit" field has many other values than just "555", but none are associated with the "999" from "Account".

How would I go about populating/associating the other values in field "Account Unit", for example, "444" or "333" with the value "999" from "Account"

Is it possible to do this in the actual dashboard (within a chart or table)? I'd rather do that than on the script, or load level.

Thanks!

Re: Populating a column with Non-associated values

Thu, 06 Dec 2012 03:18:32 GMT

LOAD Account,

[Account Unit]

from ur qvd;

left Join

LOAD * Inline

[

Account, Account Unit

999,444

999,333

];