10221 Data COmpare missing one line on left side

[chrisjj]

I have some files on which the Text Compare shows all lines, but Data Compare misses the first on the right:

http://img211.imageshack.us/img211/4268/scr2700510.jpg

Is this because some auto-detect has eaten it as field titles? In which case, how do I prevent this?

[Michael Bulgrien]

In the Columns tab under Session Settings, right-click on a column header and choose "Reset Names".
Also, if you want to preserve the order of your text file, make sure you've enabled the "Unsorted alignment" checkbox.

[chrisjj]

> In the Columns tab under Session Settings, right-click
> on a column header and choose "Reset Names".

Thanks, but has no effect here (build 10221)... as expected from Help:

To revert all columns to automatic naming, select Reset Names

> Also, if you want to preserve the order of your text file,
> make sure you've enabled the "Unsorted alignment" checkbox.

Good to know - thanks.

[Erik]

To identify whether the first line of the file is the header or a regular row, you'll need to edit the appropropriate Data Format (<default> in your case). Switch to the Type page, and change First line contains (to Cell data in your case).

[chrisjj]

> Switch to the Type page, and change First line contains (to Cell data in your case).

Thanks. I see the current setting is Detect. Wouldn't that be expected to choose Cell data in this case? I.e. from the fact that the first and second rows have high similarity.

[Erik]

Hi Chris,

If you send the files to [email protected], I can determine why the detection is not working as you expect.

[chrisjj]

Thanks - done.

[Erik]

I don't think you sent the same 2 files you were comparing in your original screenshot. Can you send those files instead?

Thanks,

[chrisjj]

> I don't think you sent the same 2 files you were comparing in your original screenshot.

Correct (sorry not to say) - they were not files, just clipboard content...

> Can you send those files instead?

... which I no longer have.

The files I sent show a similar Detect failure, no? If not, I can attempt to reproduce the first case.

[Erik]

I'm not able to get a detect failure with the files you sent. If you can't either, please send me a different set of files. Your settings and instructions would also be useful.

Thanks,

[chrisjj]

> I'm not able to get a detect failure with the files you sent. If you can't either,

I can: http://img134.imageshack.us/img134/8660/temp.gif

Do you get something different?

[Erik]

I do not see detected column names like in your screenshot. Please send your settings files (Help -> Support) and I'll try to reproduce it using them.

Thanks,

[chrisjj]

> I do not see detected column names like in your screenshot.

"King of Rhythm 1937-1944" is a detected column name, surely??

[Erik]

Nope, the first and second line have the same format so it shouldn't be detecting column names. Is it possible you assigned names (ex. "Fill Names Using Left File")? Please send your settings.

[chrisjj]

>> "King of Rhythm 1937-1944" is a detected column name, surely??
> Nope, the first and second line have the same format so it
> shouldn't be detecting column names.

I would like to 100% clear here. Are you are saying this is NOT a detected column name?