Order of Columns

Hello -

I spent a lot of time getting the fields for my Join in the order I need them, but when I run it the results display the columns in a completely different order. Is there a way to get my results to display in the order I set in the Configuration window for the Join? I would also like my export to Excel to be in that order.

Thanks

Help

Accepted answers

MarqueeCrew

@JBO,

If you order the fields in the join, you will get the data to output (from the J anchor) in exactly that order. If you should take the L or R anchor data, then you need to specify the order post the join tool with a Select. In my example workflow, you can see that I join data together and weave the fields into a format that is preserved and ready for Excel output.

I hope that this helps you.

Cheers,

Mark

oRDER OF cOLUMNS.yxmd

All comments

MarqueeCrew

@JBO,

I hope that this helps you.

Cheers,

Mark

oRDER OF cOLUMNS.yxmd

JBO

Thank you!

brad_j_crep

Is there a way to order them dynamically? I have two groups of data. One is columns of percentages the other is columns of indices.

What I'd like to see is:

I'd be fine with the above solution but there could be anywhere from 1 to 5 rings and I don't think the above will work for a dynamic list. Any ideas?

Thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703