I have an excel file that will be read into Pipeline Pilot using 'Excel reader (Cross Platform)'.
Original Excel file format
Property A Property B Property C
1 2
1 2
1 2
(use excel reader to read into Pipeline Pilot)
Property A Property B Property C
1 2
1 2
1 2 (above is what it will look like in HTML table viewer. The value '2' from Property C becomes Property B's data value.) It doesn't happen to all excels file that are read into the Pipeline Pilot. But, only to some files that I have changed the dataset many time. What could be the problem? I did check to make sure the records are in where they are supposed to be.