Clever Geek Handbook

PDI Kettle Column Values

I have a PDI transformation (Kettle)which executes the SQL script, the output of the scripts looks like this:

sign1

sign2

val3

val4

"more values" ...

I only need to write this in one Excel cell:

val1 val2 val3 val4 "more values" ...

How can i do this?

I tried "line denormalizer" and "line flattener" but doesn't work (I don't know why)

+3


source to share


1 answer


Flatender is an option, but you're in trouble because you don't know the number of new fields and separator. But there is a "trick" to solve your problem:

You can do this by following these steps:

  • Add constant after input, name: test, type: string, value: a
  • Group by new field test, aggregate your field with values ​​with Combine Rows Separated, and set space as separator.


Output:

val1 val2 val3 ....

+6


source






More articles:


All Articles