LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
  • 1.  Unicode to string conversion error

    Employee
    Posted 07-21-2016 07:43

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    I am following the example of the attached brg (provided on an older post in this forum -- someone was having a similar problem a couple of years ago) to convert Unicode data to string prior to concatenating with another data set (which is already string data). I am getting an error message of "Input length = 1" when running this node, despite 191,090 rows to the "input data" pin and 258 rows to the "metatdata changes" pin. Any help would be appreciated!
    Thanks,
    Rebecca
    Attachments:
    convertUnicode.brp
    convertUnicode.brg


  • 2.  RE: Unicode to string conversion error

    Employee
    Posted 07-21-2016 07:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    Interestingly, I get the same error trying to re-import the Excel file where the data came from in the first place - but this time I set the Default Type in the Optional tab to string. What causes this -- what is it I need to strip out of the data?


  • 3.  RE: Unicode to string conversion error

    Employee
    Posted 07-21-2016 09:09

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ltolleson

    Rebecca,

    Can you post the full error message. CTRL+RightClick on the node with the error will popup a window with the full error text. You can then copy and paste that message into the forum.

    Also, do you know specifically which node is giving the error? I have included an updated version of the conversion graph that is more efficient than the version you have posted here.

    Thanks,
    Larry
    Attachments:
    convertUnicode.brg