Alteryx Output LoanID_RSeller Number_RPrin Amount_Int Amount_Total _25% Recovery Fee _LienTDRNO1st5000500125SRLoss Recoveries NCB -SRYES2nd1376.6301376.63344.16JR - TDRloss Recoveries NCB TDR JRNO2nd198101981495.25JRLoss Recoveries NCB -JR Manual Output NO2nd 1,981.00 - 1,981.00 495.25JRNCB JRYES2nd 1,376.63 - 1,376.63 344.16JR - TDRNCB TDR JRNO1st 500.00 - 500.00 125.00SRNCB SRYES1st - - - - SR - TDRNCB 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

Add Dummy row when data is not available

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

AMP Engine

AMP-Engine

Accepted answers

nagakavyasri

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

Screenshot 2024-09-17 143927.png

9-17-24.2.yxmd

All comments

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

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

Screenshot 2024-09-17 143927.png

9-17-24.2.yxmd

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703