Forum Discussion
Merge sort with alternative sort orders (EBCDIC vs ASCII)
Hi emarc1 ,
You may create a custom column or merge with a table which contains your item codes and the corresponding sort number, and then sort it by the number column.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The order of the items in both tables is the same, because they both come from the original table in SQL. It just seems to be that them not being in ASCII order seems to cause PQ some issues.
Wouldn't I find that creating a custom column, merging, and sorting on that would be just as slow as just having PQ sort the columns anyway?
I'm also seeing if I can get the source data to be outputted with an ASCII sort order but it could be tricky.