LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Bryt Park

Hi

I am trying to transpose a matrix with 'Pivot - Data To Names' Node, but the outputting fields seem to be out of the original order:

Here's what my input data look like:

MyData, MyFieldName
Field1, Account
Field2, ID
Field3, Order ID

Here are the outputs:

ID, Account, Order ID
Field2, Field1, Field 3


I would expected the output fields to go by the exact order as the input like: Account, ID, Order ID

Can anyone show me how to do it? Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Bryt,

What version of LAE are you running? I just tested this on LAE 6.0 and got the results you are expecting. When you open the output, select "Actions"->"Reset Column Order". This will clear any saved column order in the viewer that might be showing the wrong order.

Thanks,
Larry

Originally posted by: Bryt Park
					

Hi


I am trying to transpose a matrix with 'Pivot - Data To Names' Node, but the outputting fields seem to be out of the original order:


Here's what my input data look like:


MyData, MyFieldName

Field1, Account

Field2, ID

Field3, Order ID


Here are the outputs:


ID, Account, Order ID

Field2, Field1, Field 3



I would expected the output fields to go by the exact order as the input like: Account, ID, Order ID


Can anyone show me how to do it? Thanks!