Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to creat a new field in my table that ranks the instance of TR.REF for each SORDREF.
So, instance of TR.REF 282117 for SORDREF 142871 is 1, instance of 283479 is 2, etc as per below
DATE | SORDREF | TR.REF | ITEMCODE | NEW FIELD |
04/01/2010 | 142871 | 282117 | 33E01 -(222901) | 1 |
04/01/2010 | 142871 | 282117 | 33E10 -(222902) | 1 |
04/01/2010 | 142871 | 282117 | MTCRCA09 | 1 |
04/01/2010 | 142871 | 282117 | ZR5RT011 | 1 |
04/01/2010 | 142871 | 282117 | 1722.47 | 1 |
04/01/2010 | 142871 | 283479 | 333E - (222964) | 2 |
04/01/2010 | 142871 | 283981 | 1707 | 3 |
04/01/2010 | 142871 | 285213 | ZR5MF011 | 4 |
04/01/2010 | 142872 | 282070 | 10060653 | 1 |
04/01/2010 | 142872 | 282070 | 10066401 | 1 |
04/01/2010 | 142873 | 282071 | 10060653 | 1 |
04/01/2010 | 142874 | 282049 | 013 - 4 | 1 |
04/01/2010 | 142874 | 282049 | 4861.063 | 1 |
04/01/2010 | 142874 | 289943 | 2202.0315 | 2 |
04/01/2010 | 142874 | 289944 | 2202.0315 | 3 |
04/01/2010 | 142875 | 282036 | 690 DZII | 1 |
04/01/2010 | 142876 | 282057 | BB2718 | 1 |
04/01/2010 | 142876 | 282057 | E2718O | 1 |
04/01/2010 | 142877 | 282079 | OBS/4863.063 | 1 |
PS - am a Personal Edition user
I'm not sure why you get an error by just looking at the error message. Can you post your script to investigate the source of the error?
Regards.
Hi Karl
Script attached.
Joe
Hi Karl
In fact i had commented out the Final Table section. In the meantime, I noticed that I had inserted a new LOAD statement from Custs1.csv.
In fact the script is as per attached.
Joe
You named the table TRANS1 then tried to refer to it as Trans1. I believe QlikView is case-sensitive.
Thanks John.
New Error "Field Names must be unique within table".Can you take a look?
I may be overstaying my welcome on this post, but hopefully this will be the last issue.
Joe
You're doing this:
Load *, DEL_COUNT
So you're telling it to load ALL fields, and then repeating DEL_COUNT. You can't load DEL_COUNT twice in the same table. If you were trying to add a field to avoid the automatic concatenation, that's not the way to do it. Instead, use noconcatenate.
Final_Table:
NOCONCATENATE
LOAD *
RESIDENT TRANS1
...
Hi John / Karl
The script now runs error free. I have to say I'm not sure whats going on with that part of the script. It seems to have created additional syn keys, which I also don't understand.
All things I can investigate myself in time.
Time to move on.
Thanks for all your help.
Joe
You are probably needing a
Drop table TRANS1;
at the end of the script.