Skip to main content
Question

Changing order of columns in "TableAdder"

  • June 21, 2017
  • 6 replies
  • 32 views

Forum|alt.badge.img

I'm using the custom transformer "TableAdder" to create a table. But the columns are placed alphabetically - left to right - but I want to change the way they are placed. How can I do that?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

6 replies

mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • June 21, 2017
I'm taking a look at this transformer and will get back to you shortly. I think it also needs fixes for missing/null values, which weren't available when it was first implemented.

 

 


mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • June 21, 2017

OK, I tried to make some updates, but there's some other issue that causes the text to just keep disappearing. Looks like the 'b' word! I've filed a report with our developers, but it does mean I can't really do much to update the transformer. At a glance I would say re-sort the data after the AttributeExploder_2 transformer. There is a Sorter there that might be setting the order, so check that too.

Hope that helps.


mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • June 27, 2017

OK, I tried to make some updates, but there's some other issue that causes the text to just keep disappearing. Looks like the 'b' word! I've filed a report with our developers, but it does mean I can't really do much to update the transformer. At a glance I would say re-sort the data after the AttributeExploder_2 transformer. There is a Sorter there that might be setting the order, so check that too.

Hope that helps.

The dev team fixed the b*g that caused text to disappear (2017.1, build 17516) so I will install that when available and see if I can make the updates you need.

 

 


mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • June 28, 2017

OK, I tried to make some updates, but there's some other issue that causes the text to just keep disappearing. Looks like the 'b' word! I've filed a report with our developers, but it does mean I can't really do much to update the transformer. At a glance I would say re-sort the data after the AttributeExploder_2 transformer. There is a Sorter there that might be setting the order, so check that too.

Hope that helps.

OK, so I have it working now, but I still don't think there is a good way to set the column order. The Select Attributes parameter doesn't let you pick the order. It's filed as PR#64217, but I don't see that one being fixed quite as quickly. So, for now, I have no way to resolve this one. Sorry.

 

 


Forum|alt.badge.img
  • 21 replies
  • October 29, 2019

OK, I tried to make some updates, but there's some other issue that causes the text to just keep disappearing. Looks like the 'b' word! I've filed a report with our developers, but it does mean I can't really do much to update the transformer. At a glance I would say re-sort the data after the AttributeExploder_2 transformer. There is a Sorter there that might be setting the order, so check that too.

Hope that helps.

Any update on this please? I also need to reorder the columns.

Thanks


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • 2252 replies
  • October 29, 2019

i posted a table builder not long ago.

One part that the user set a sorting order on any column.

The sorting order is entered prior to tablebuilding. Either manualy like a mapper, or by providing a sort map (txt,csv etc.)

 

Hav'nt seen any reactions to it though. Maybe i should not have named it "Tabel messing ... again" ?

Here is one where the column order is added trough a attributecreator.

Tabel messing ... again.fmwt