We have observed that when there is white space at the end of a row in a tabular dataset, and that dataset is used in a "compare two datasets", any trailing columns that contained whitespace or an empty string in the first row disappear from every row in the output.
For example, if we compare the following dataset against itself, keeping all the rows in the first dataset...
line 1 A B C line 2 A B C D line 3 A B C D E F G H line 4 A B C D E F G H
The result we see is:
line 1 A B C line 2 A B C line 3 A B C line 4 A B C
We would like to be able to join and compare datasets that will contain empty strings as in this examp Please let me know if you need any more information about the bug we are seeing.
Many thanks Jo