Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Why is a 'Qualify' statement adding an extra column (tablename.tablename.date) multypling my total row number and altering the records' names in a 'Crosstable' statement?
Thanks in advance.
[Incorrect]
Input:
Output:
[Correct]
Input:
Output:
I must admit that I had never tried to combine qualify and crosstable and I think it's really inappropriate to each other. I assume that behind this feature is a kind of loop which concats everything together and that your noticed behaviour is caused from that. In general you shouldn't apply any transformations on crosstable and doing it afterwards within a resident-load (lesser problems and I assume a better performance will follow).
- Marcus
Qualify is like a very strong poison. Carefully used by certain situations it could be useful but applying to (nearly) each load is the opposite of it and could create a varity of problems ...
Beside this I would adjust it in this way:
- Marcus
Thanks, I added that Unqualify statement just to make it clear what was being done. Nevertheless, do you know why the Qualify statement does that? Does that mean that Qualify is simply inappropiate for the statement Crosstable?
I must admit that I had never tried to combine qualify and crosstable and I think it's really inappropriate to each other. I assume that behind this feature is a kind of loop which concats everything together and that your noticed behaviour is caused from that. In general you shouldn't apply any transformations on crosstable and doing it afterwards within a resident-load (lesser problems and I assume a better performance will follow).
- Marcus