Max columns for External Lookup

Charles_22373
Charles_22373 New Altair Community Member
edited March 2019 in Community Q&A
Trying to create an external lookup to a table with a large number of columns.  On the External Lookup Fields tab, Monarch 14 only seems to show the first 100 columns and is not showing me the column I'm looking for.  Is this a limitation or is there a configuration somewhere?

------------------------------
Chuck Zawadski
Principal Engineer
People's United Bank, National Association
BRIDGEPORT CT
------------------------------
Tagged:

Answers

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited March 2019
    Hi Chuck,

    I tried it with an Excel external lookup file in Monarch 14.3 and I could see the first 255 columns. 

    What 'sub' version of Monarch and file formats are you using?

    As a workaround, would it be possible to 'prep' your external lookup as a separate process into a more manageable file?

    Regards,
    Steve.


    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-28-2019 09:21 AM
    From: Charles Zawadski
    Subject: Max columns for External Lookup

    Trying to create an external lookup to a table with a large number of columns.  On the External Lookup Fields tab, Monarch 14 only seems to show the first 100 columns and is not showing me the column I'm looking for.  Is this a limitation or is there a configuration somewhere?

    ------------------------------
    Chuck Zawadski
    Principal Engineer
    People's United Bank, National Association
    BRIDGEPORT CT
    ------------------------------
    "
  • Charles_22373
    Charles_22373 New Altair Community Member
    edited March 2019
    Steve Caiels_21881 said:

    Hi Chuck,

    I tried it with an Excel external lookup file in Monarch 14.3 and I could see the first 255 columns. 

    What 'sub' version of Monarch and file formats are you using?

    As a workaround, would it be possible to 'prep' your external lookup as a separate process into a more manageable file?

    Regards,
    Steve.


    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-28-2019 09:21 AM
    From: Charles Zawadski
    Subject: Max columns for External Lookup

    Trying to create an external lookup to a table with a large number of columns.  On the External Lookup Fields tab, Monarch 14 only seems to show the first 100 columns and is not showing me the column I'm looking for.  Is this a limitation or is there a configuration somewhere?

    ------------------------------
    Chuck Zawadski
    Principal Engineer
    People's United Bank, National Association
    BRIDGEPORT CT
    ------------------------------
    "

    I am running 14.3.1.7681.  The table I'm trying to access is in a Sybase database.  I have since tried a table in a SQL Server database and did retrieve more than 100 columns so it appears it could be something to do with Sybase.

    ------------------------------
    Chuck Zawadski
    Principal Engineer
    People's United Bank, National Association
    BRIDGEPORT CT
    (203) 338-3934
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-29-2019 05:35 AM
    From: Steve Caiels
    Subject: Max columns for External Lookup

    Hi Chuck,

    I tried it with an Excel external lookup file in Monarch 14.3 and I could see the first 255 columns.

    What 'sub' version of Monarch and file formats are you using?

    As a workaround, would it be possible to 'prep' your external lookup as a separate process into a more manageable file?

    Regards,
    Steve.


    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------

    Original Message:
    Sent: 03-28-2019 09:21 AM
    From: Charles Zawadski
    Subject: Max columns for External Lookup

    Trying to create an external lookup to a table with a large number of columns.  On the External Lookup Fields tab, Monarch 14 only seems to show the first 100 columns and is not showing me the column I'm looking for.  Is this a limitation or is there a configuration somewhere?

    ------------------------------
    Chuck Zawadski
    Principal Engineer
    People's United Bank, National Association
    BRIDGEPORT CT
    ------------------------------
    "

Categories