Skip to main content
Question

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

L

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?

 

 

 

 

 

 

 

 

 

2 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • January 20, 2021

@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'
L
  • left65
  • Author
  • January 29, 2021
markatsafe wrote:

@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


Helpful Members This Week

Community Stats

31,327
Posts
118,854
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

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