Inconsistent View Data in Sequential File stage
Moderators: chulett, rschirm, roy
Inconsistent View Data in Sequential File stage
Hi,
We have a Sequential File stage as source that reads a .csv file. This file has 115 records in it. The last few records have a value of -1 in one of the columns.
When we do a view data on this stage, the number of records that show on the screen are inconsistent. Sometimes it shows all records including the last few records with '-1' value, or sometimes it does not show the last few records that have '-1' value. I have the limit for view data as the highest 9999.
We would like to know if its a problem with just the view data or something to do with the format within the file.
Thanks.
We have a Sequential File stage as source that reads a .csv file. This file has 115 records in it. The last few records have a value of -1 in one of the columns.
When we do a view data on this stage, the number of records that show on the screen are inconsistent. Sometimes it shows all records including the last few records with '-1' value, or sometimes it does not show the last few records that have '-1' value. I have the limit for view data as the highest 9999.
We would like to know if its a problem with just the view data or something to do with the format within the file.
Thanks.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Inconsistent View Data in Sequential File stage
What is common in the 'sometimes' ?vnspn wrote:Sometimes it shows all records including the last few records with '-1' value, or sometimes it does not show the last few records that have '-1' value. I have the limit for view data as the highest 9999.
Re: Inconsistent View Data in Sequential File stage
I'm doing nothing differently.
I just repeatedly do a view data, and at times is shows all records and at certain times does not show the last few records with -1.
I just repeatedly do a view data, and at times is shows all records and at certain times does not show the last few records with -1.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray - I have my sampling specfication with the highest value possible, '9999'.
chulett - You have precisely stated our scenario. When we repeatedly view the exact same static data over and over using the same settings, the results are not identical. We shall get in touch with our vendor support as you have mentioned.
Thank you.
chulett - You have precisely stated our scenario. When we repeatedly view the exact same static data over and over using the same settings, the results are not identical. We shall get in touch with our vendor support as you have mentioned.
Thank you.