Originally posted by: SystemAdmin

I'am using Excel file as my input file in the wtx map, I used Database Interface Designer to be able to generate the content of the excel file. I successfully generated the content but it shows only the first row of the excel file. And an error prompt "Input invalid but unknown data found". Correct me if Im wrong, but I think the problem is the terminator. I just want to know what will be the right terminator when using an Excel file to be able to read the next row.

Hope you could help me with this one.
Thanks
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: repanzer

It was always CR/LF or NL (New Line) when I used to do this.

If you are able, view the data in hex, which I do from using map designer and viewing the input card, and click "display in hex".
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Mr. repanzer,
Thanks for the reply, I used CR/LF or NL as terminator but it gave me same result. Are there other configurations that you know that I might possibly miss? How can I view the data in hex?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: TarunB

Maybe you've selected the wrong group from the Type Tree in your Map Designer? Are you sure you haven't selected the Row group rather than the DBTable (top level) group?

Does your top level group allow multiple records - i.e. make sure your Range is set to (0:s)

I would suggest turning on the trace file and analysing that. Post it here if you get stuck.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender