0 Replies Latest reply: May 15, 2014 9:51 AM by ron cousino RSS

    Database Lookup

    ron cousino

      I have created a Monarch model to extract data from a report which has an account number that, in our database, Monarch treats as a character field that is left aligned.  So I set up my account field in my Monarch model with the properties of character, general, left aligned.  When I perform the external lookup I use the appropriate source and table fields that should match but get no return of data--and the data does exist in my database.  If I start with my database dataset, which is very very large, and perform a val function I can link the data to my extracted report data, however if I trap my field in the report as a numeric I get a source table mismatch.  What gives, it isn't practical to pull in the entire account dataset to match data for only a fraction of the database.  HELP!