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.  Correcting Errors in CSV Files

    Employee
    Posted 06-15-2016 10:26

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

    Originally posted by: arunchandra

    Hi All,

    I have a question on handling CSV errors and would be glad if you can help me with that. Please find attached the brg and the data file.

    I have created an error in the CSV file such that there is one more column than the actual data. So I acquire a CSV data node and output two pins in order for the second pin to show the data errors. What I want to do si use the same node and the error pin to correct the data. I have not been able to do that. What I am doing currently is acquire a new csv node and then create a new field name for the extra field and them remove that field.

    Can you please let me know if it is possible to correct the data using the data from the error pin itself.
    Attachments:
    Expense Data.brg


  • 2.  RE: Correcting Errors in CSV Files

    Employee
    Posted 06-15-2016 12:22

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

    Originally posted by: stonysmith

    The attached graph should do the trick
    Attachments:
    Expense Data.brg