Additional Row

RapidEndUser

Hello Support,

How can I add additional row in the result set from process.

For e.g.

I have final output from the process:-

YearColumn            UnderMedian        AboveMedian
Twoyears                  6.816                        1.067

Now I need to add one additional row to the result set.

YearColumn            UnderMedian        AboveMedian
Beginning Year          0                              0
Two Years                  6.816                        1.067


Now currently what I am doing just pick a temporary table with GnereateAttributes which contains

YearColumn          concat("Beginning Year")
UnderMedian          0
AboveMedian        0

and joining with JOIN operator.

My question instead of using temporary table can we use an operator which directly add this row?
Since the process expecting input data (which is basically we have to use some kind of table) after that only we can able to add other operators such like Generate Attributes or Filter Example or etc.,

Can I use directly Generate Attributes before put the temporary table in the process?


Thanks,
RapidEndUser

MariusHelf

Hi,

I have no idea how you managed to *join* the two tables such that you get the desired result, however, what you could do is to use Generate Data by User Specification and then use Append to add the newly generated data row to the existing data.

Btw, to define string attributes you can simply enter "Beginning Year" (with quotes) instead of using concat.

Best regards,
Marius