Skip to main content
Question

Changing order of columns in "TableAdder"


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?

6 replies

mark2atsafe
Safer
Forum|alt.badge.img+43
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+43

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+43
mark2atsafe wrote:

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+43
mark2atsafe wrote:

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
  • October 29, 2019
mark2atsafe wrote:

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
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings