Add Dummy row when data is not available

[VaishnaviGinni]

Alteryx Output

LoanID_R	Seller Number_R	Prin Amount_	Int Amount_	Total _	25% Recovery Fee _	Lien	TDR
NO	1st	500	0	500	125	SR	Loss Recoveries NCB -SR
YES	2nd	1376.63	0	1376.63	344.16	JR - TDR	loss Recoveries NCB TDR JR
NO	2nd	1981	0	1981	495.25	JR	Loss Recoveries NCB -JR

Manual Output

NO	2nd	1,981.00	-	1,981.00	495.25	JR	NCB JR
YES	2nd	1,376.63	-	1,376.63	344.16	JR - TDR	NCB TDR JR
NO	1st	500.00	-	500.00	125.00	SR	NCB SR
YES	1st	-	-	-	-	SR - TDR	NCB TDR SR

Now my question is the last row of manual output has no data so it is showing as blank

but in Alteryx output after summarization only 3 rows are coming but I need 4th row also.

And one more thing in future months any row can have no data but that row should come.

Please suggest

[ChrisTX]

I think you mentioned the problem seems to be coming "after summarization".  what is the input going into the summarization?

for each unique value of Seller Number_R, do you always want rows for LoanID_R with value Yes and No?

please clarify the question.

[KGT]

Yep, agreed, more information will help. What exactly has to be added back on. If a group has no data going into the summarise, then it won't come out the other side. 

Joining on the data that is needed (template) with all right fields deselected, so you will get:

J=data that has already been included

L=data that doesn't match your template

R=missing rows

That will then provide you with the outputs you need to union to get your dataset.

[nagakavyasri · Accepted solution]

Hi @VaishnaviGinni unioning all outputs from Join makes sure that all the inputs are present in output.

[VaishnaviGinni]

Thank you so much it is working for me.

[VaishnaviGinni]

Yes problem is coming after summarization only. So value is there or not but I need that row for display purpose. 

All four rows should come whether value is there or not