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.

[sn2200]

thank you @apathetichell  for your comment but i am not able to follow. Could you please help build a sample workflow, that'll be very helpfull? 

Thank you again!

[apathetichell]

Hey --- don't have a designer license currently - so just follow my instructions and let me know where you hit an issue.

[RJ_1988]

Here is the attached solution.

[sn2200]

@RJ_1988  thank you for your help. if the data is vstring then it is not working. Can you please try with the below data?

a	c	f	b	h	g
asoo	dyhjjj	tuin	nh	eiouio	mjbjh
gnhhd	opai	wkjlkj	kiikk	mjjj	bhjhg
vbn	mjjh	wty	pooi	ikkz	uu

[RJ_1988]

Is the data structure going to remain the same or is it dynamic ?