Alteryx Designer Discussions

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

Text File as Input file

marlontalisvistar
9 - Comet

Hi

 

I have file converted to text file and I am hoping to get the value of "DDC BAU Mailbox" with total loan count of 296 and "DDC NPC Resolution-Salability" with total loan count of 10. Can someone to kindly share me a workflow? I am  trying to put this into column format but I am not able to do it. 

 

Please see attached text file.

 

 

5 REPLIES 5
vlad_kutateladze
7 - Meteor

Hi. Not very clear for me what output you are looking for. But try this: 

 

vlad_kutateladze_0-1633947147091.png

 

marlontalisvistar
9 - Comet

Hi @vlad_kutateladze 

 

Thanks for the response. Is it possible to get only the total which is 296 for DDC Bau Mailbox and 10 for DDC NPC Resolution-Salability?

 

Looking forward.

 

Thanks,

 

Marlon

Luke_C
14 - Magnetar

Hi @marlontalisvistar 

 

I tweaked @vlad_kutateladze 's solution a bit to get you this: 

 

  1. Updated the multirow formula slightly to return a numeric value
  2. Sorted the data from high to low
  3. Sampled the first record for each DDC grouping

 

Luke_C_0-1634057683783.png

 

marlontalisvistar
9 - Comet

Thanks @Luke_C, This is the exact solution I am looking for. Again Thank you so much.

marlontalisvistar
9 - Comet

Hi @Luke_C ,

 

can you also help me extract the date as additional field. I'm sorry if I missed this one. See sample screenshot.

 

marlontalisvistar_0-1634400759458.png

 

Labels