sabarikanth
New User
Joined: 07 Jun 2010 Posts: 59 Location: coimbatore
|
|
|
|
Bill,
Quote: |
Although your input file looks different, your parameters should help the TS to get somewhere as, as you say, one record has been deleted (I assume you have checked that it is the correct one). |
I didnt use a different input file.. i'm using the same file(VB 32000) as input with 'SUB' in position 11.
I think the parameter 'SUB' is in 11th position. It has been confirmed by Shan in previous conversations.....
Thanks,
Sab. |
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
sabarikanth wrote: |
Bill,
Quote: |
Although your input file looks different, your parameters should help the TS to get somewhere as, as you say, one record has been deleted (I assume you have checked that it is the correct one). |
I didnt use a different input file.. i'm using the same file(VB 32000) as input with 'SUB' in position 11.
I think the parameter 'SUB' is in 11th position. It has been confirmed by Shan in previous conversations.....
Thanks,
Sab. |
Hi Sab,
Well, your file looks different. Look at your display in your post and look at the original. Different?
With a VB file, you have the RDW. SORT still wants you to take the RDW into account when specifying your parameters. 11 from the original example includes the 4 for the RDW, so in the data SUP starts at position 7. In your file, you start at 11 in the data, which requires 15 in the sort parameter.
Any answer at all on why you swapped the conditions around? Last time that I ask. |
|