Populating a column with Non-associated values

[#1]

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!

[#2]

LOAD Account,

     [Account Unit]

from ur qvd;

  left Join

LOAD * Inline

[

Account, Account Unit

999,444

999,333

];