Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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
get your questions about inspire answered by inspire attendees
learn more about the python upgrade coming in may 2024
Labels