I get flat files that I'd like to 'flip' to accommodate the multi-value
database. For example, given this table:

 

123456<vm>DAVID JONES<vm>1234 MAIN ST.<vm>ANYWHERE<vm>MI<vm>12345<am>

654321<vm>JOHN SMITH<vm>4321 MAIN ST.<vm>ANYWHERE<vm>MI<vm>12345

 

Is there a function that will change it to:

 

123456<vm>654321<am>

DAVID JONES<vm>JOHN SMITH<am>

1234 MAIN ST.<vm>4321 MAIN ST.<am>

ANYWHERE<vm>ANYWHERE<am>

MI<vm>MI<am>

12345<vm>12345

 

Right now I use these nested loops, which tend to take a while depending
on the size of TABLE:

 

NEW.TABLE = ""

 

FOR A1 = 1 TO DCOUNT(TABLE,@AM)

  FOR V1 = 1 TO DCOUNT(TABLE<A1>,@VM)

    NEW.TABLE<V1,A1> = TABLE<A1,V1>

  NEXT V1

NEXT A1

 

TABLE = NEW.TABLE

 

Sincerely,

David Laansma

 

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to