community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data gaps

Niru
8 - Asteroid
‎02-16-2021 02:49 AM

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula
‎02-16-2021 02:58 AM

Hello @Niru ,

 

how about this?:

 

Untitled.png

 

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

 

Regards

fill_rows.yxmd
Reply
Niru
8 - Asteroid
‎02-16-2021 03:11 AM

 

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

 

Reply
learn more about the python upgrade coming in may 2024
Labels