How to Generate extra row based on condition

[Ekmi9]

Hello All,

How i an generate extra row in the data based on condition. Purely dynamic way.

For example : If i have Jan and Feb. month data and then i have April month data but on final report i want say i have Jan to April data with March row count is zero. this only one but will have many other condition as well.

Can anyone help on this ?

Appreciate your help ! 

Thanks in Advance! 

[binuacs]

@Ekmi9 have you tried the generate rows tool ,also your requirement is not clear, are you expecting data for march as well in your output file?

[OTrieger]

@Ekmi9 
You request is too generic to understand which conditions you will have for the creation of the additional row. As @binuacs wrote you can use generate rows tool, which will be one of the ways how to do it. However as your post is not in details it is hard to pin point what you are really after.

[Ekmi9]

Yes

[binuacs]

@Ekmi9 Can you provide a sample input and expected output for better understanding?