LAE

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

Originally posted by: writetoshrinivas

Hello,

Im new to the Lavastorm Desktop Platform. I'm trying to import a delimited file (*.dat format, Pipe delimiter). I used the Pipe symbol as the field delimiter (without quotes) and \n as the record delimiter.

"Got two columns, but expected only one. Adding a second pin will supress the error status..."

Not sure what im doing wrong.

Please advise

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

Originally posted by: Tim Meagher

Hi,

It looks like either the first record contains no pipe character, or you are specifying the FieldNames with only one value.
The error message indicates that it is expecting to only receive one field, which would occur either:

• If you specify only one field name in the FieldNames parameter and one of the records contains two fields, or
• If you don't specify a value to the FieldNames parameter and the first record does not contain a pipe character, or the pipe character is contained within quote characters (if those are specified)

If you add a second output pin to the node, then the records which don't match what the node is expecting will be written to that output, and you can figure out how to resolve the problem from there.

Regards,
Tim.