Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Data gaps

Nirukk
7 - Meteor

Hello All,

 

kindly help me to get below mentioned output.

INput:

LOB IDAMAWM OpsIPBUS PBUS WMWM (Detail Deck Only)Chase AutoBCCBusiness BankingCard ServicesCCB OpsConsumer BankingData & AnalyticsDigitalHome LendingMarketingCCB FinanceCCB HRCCB StrategyCCB Technology
US WM125533NANANANAUS WMNA              
CREDIT CARD125533      NANANACREDIT CARDNANANANANANA    

 

Expected Output:

LOB IDAMAWM OpsIPBUS PBUS WMWM (Detail Deck Only)Chase AutoBCCBusiness BankingCard ServicesCCB OpsConsumer BankingData & AnalyticsDigitalHome LendingMarketingCCB FinanceCCB HRCCB StrategyCCB Technology
US WM125533NANANANAUS WMNANANANACREDIT CARDNANANANANANA    
CREDIT CARD125533NANANANAUS WMNANANANACREDIT CARDNANANANANANA    

 

Thanks & Regards,

Niru

 

 

 

 

 

 

 

 

 

 

 

 

 

 

afv2688
15 - Aurora
15 - Aurora

Hello @Nirukk ,

 

how about this?:

 

Untitled.png

 

I have set up the condition to fill only based on the rows having the same id

 

Regards

Nirukk
7 - Meteor

 

@afv2688 Thanks a lot, i got the expected solution. 

 

Labels