Save output fields in sequence as per lookup file

sn2200

i am trying to get the output fields in the same sequence as per the lookup file, please assist.

Data

a	c	f	b	h	g
12	23	45	67	78	45

LOOKUP FILE

a

b

c

d

e

f

g

h

Desired Output

a	b	c	d	e	f	g	h
12	67	23			45	45	78

apathetichell

attach a recordid to the lookup table.

use dynamic rename to match column names --- taking the column name from the numeric column.

your columns now have numbers for names.

use select tool ---- sort column names---- ascending.

use dynamic rename --- this time match the numbers back to the letters.