Hoping I can get some help here.

I have an attribute in a file that is 3 multivalues. (Basically a
category that is generated from each type of calculation)

ex
ATTRIBUTE 1: A]D]B

I'd like to be able to select on them and order by the specified
multivalue field. I was hoping to use group extract in the DICT but it
apparently ignores value marks.

My thought would be to use the t correlative to extract it.
something like:
tFILE;X[2];1;1 to return D

I'm uncertain of the syntax though as playing around with it has not
gotten me anywhere.

This is on D3 7.5.1 (Aix)

One thing to note if it makes any difference,
The file I'd be pointing at with the translate correlative is the same
file that the DICT is for.

On Nov 29, 2:23*pm, Sean Chapman <sean.chap... (AT) gmail (DOT) com> wrote:

I think most platforms will support:

TFILE;X1;;1 (Will produce 'A')
TFILE;X2;;1 (Will produce 'D')
TFILE;X3;;1 (Will produce 'B')

Ed

"Sean Chapman" <sean.chapman (AT) gmail (DOT) com> wrote

The closest I've been able to get is
On:
K:10R8999
001 15674]15674
002 C]B
003 52056]26028

Using:
08 TP.INVX;V2;;1

[708] 'C' cannot be converted.


On Nov 29, 3:28*pm, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:

X just brings back blank.

On Nov 29, 3:35*pm, Sean Chapman <sean.chap... (AT) gmail (DOT) com> wrote:

I just tested it on mvBase and it worked fine. WHich platform are you using?

Ed

"Sean Chapman" <sean.chapman (AT) gmail (DOT) com> wrote

X just brings back blank.

On Nov 29, 3:35 pm, Sean Chapman <sean.chap... (AT) gmail (DOT) com> wrote:

d3 7.5.1

Here is the exact dictionary and item involved
Sample item:
:CT P.INVX

C:3803710RX
001 15674]15674
002 C]A
003 81923]81923

dict item
:CT DICT P.INVX CAT2

CAT2
001 S
002 2
003 CATEGORY ACTIVITY
004
005
006
007
008 TP.INVX;X2;;1
009 L
010 1

output

:list p.invx c:3803710RX cat2
Page 1 p.invx

p.invx.... CATEGORY ACTIVITY

c:3803710R

output 2:
:SELECT P.INVX WITH CAT2 NE ""
[401] no items present.






On Nov 29, 3:40*pm, "Ed Sheehan" <NOedsS... (AT) xmission (DOT) com> wrote:

On Nov 30, 9:52*am, Sean Chapman <sean.chap... (AT) gmail (DOT) com> wrote:
Sean,

I think that you need to put 0 in att2 & 2 at the end of the translate
- i.e.
S
0
category activity

TP.INVX;X2;;2

this uses 0 (id) to do the translate & picks up att2 from the file &
gives you mv 2 .
What you were doing was using att 2 to read the file & returning att
1.

Geoff

Thanks Geoff,
the 2 in Attribute 2 was the missing part. Thanks for the help.

On Nov 29, 4:06*pm, Geoff Goodchild <geoffgoodch... (AT) gmail (DOT) com> wrote:

001 S
002 0 <---
003 CAT2
004
005
006
007
008 TP.INVX;X2;;1
009 L
010 1


:SELECT P-INVX WITH CAT2 NE ""

[404] 1 items selected out of 1 items.