Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I am trying to transform a list of data from a sql table to table like format - probably not making sense so I'll try an explain more

The following is how the data comes in using SQLCreator

beforeAnd this is how i want it to look

afterThe other tricky part is that there is no limit on the number of nar_num records (rec_seq) that can be linked to a single ass_num - at the moment I have a max of 17 but that could go up or down

 

I looked at the pivoter and didnt have any luck with that but i am new so maybe i am missing something.

Anyone have any ideas?

 

 

 

 

 

 

 

 

 

@left65​ A combination of Aggregator followed by the HUB Custom transformer ListBreaker should do it.

  • Aggregator - use Group By : ass_num and create a list from attribute 'nar_num'. Use Mode: Attributes Only (or you could try ListBuilder)
  • ListBreaker - break up the list of 'nar_num'

@left65​ A combination of Aggregator followed by the HUB Custom transformer ListBreaker should do it.

  • Aggregator - use Group By : ass_num and create a list from attribute 'nar_num'. Use Mode: Attributes Only (or you could try ListBuilder)
  • ListBreaker - break up the list of 'nar_num'

Thanks Markatsafe

Reply


Community Stats

30,185
Posts
114,569
Replies
37,848
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.