Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I store files into CSV format. However, I am not sure in what order it is sorting the data.
Anyway, I would like to sort the file. I am storing the file as below, and I have no clue the way it sorts. I would like to have at least a few fields that I sort on, so that it makes at least a little sent, instead of being all randomly sorted.
Store Revrec1 into \\MMX111VSWSQV1\MappingF\Rev_BL1.qvd;
Or is it possible to sort it when reading from the QVD file (Rev_BL1.qvd)?
Not quite sure what you mean by having the identical name for two tables. To me it looks like I have been using the same logic you suggested?
Thanks
I have attached a modified version of you QVW that shows how it can be fixed both in the load script and in the UI.
You have to read up on the link I sent you about "auto concatenation".... You can avoid it by using a prefix to the load statement called NOCONCATENATE. Anyways I posted a solution for you where I have fixed the load script issue and given a solution as to how to get QlikView to use alphabetical sort on a specific field...
Thanks for your help.
Wow, that was a lot more complicated than I expected! I have approximately 100 fields in the database, so I hope it will be possible to replicate.
I will study your solution, and see if I can make it work.
Thanks again.
Please click LIKE (thumbs up) on one or more of my responses because that is the only way you can reward anyone that helps you on this forum... 🙂
I guess that all the 100 fields doesn't need to have alphabetical sort... People design QlikView applications for years without getting in to trouble or even notice that it is not alphabetical sort.