Same field and value...but two records

[#1]

I have this file, and the AlphaProdID field is always LocalBoise as you can see.

I run it through this QVW to format it, but I get 2 LocalBoise in the AlphaProd Field

I have attached all necessary sample data.

Even if you just drag it in to Qlikview, then separate it by SOH delimiter, you will see two of the same LocalBoise under AlphaProdID

Please, any help is appreciated.

[#2]

Oh, actually this solution works for small amount of data, but not my large amount.

This is because for one of the fields, location, sometimes it is null.

So if you delimit on spaces, it will just skip it, and this messes up the other values.

[sunny_talwar]

Makes total sense now.... Look here what I find when I export Data24 into an Excel

Have no idea what is going on here... why is one of the them with item.... would you know of anything?

[sunny_talwar]

I get why you don't want to use spaces and it totally makes sense. You can keep your thread open because you still might need advice from other people....

[#5]

Is there a hidden 'item' on the end of that Boise?

Is there any way to fix this in qlikview script?

[#6]

Sunny, I have some insight into this issue.

The item appended on to the end is from the first column, @1, which is item

When I run my whole data doc in to my qvd generator with the subfields, it creates errors like this.

See the Inventory Cost Count? This is not in the data, this is a field name that I put in to count the number of rows in my data. You can view all of this in the QVW attached earlier.

This data should only have one date, the month end, but now it looks like this after running through my qvd generator.

Do you see anything wrong with my QVW?

[sunny_talwar]

No, I don't... I really don't know why it is doing this

[#8]

Hmm...OK. I'll look into it, and if I can't find anything I may open another forum question.