Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Complex file - cleaning is needed

SH_94
11 - Bolide

Hi community,

 

I would like ask how to clean and amend the workflow to produce the result as below:

Original file

SH_94_0-1634059184102.png

 

Result Desired

SH_94_1-1634059670370.png

Could you anyone guide me on how to produce the result above based on the samples format given?

 

Thank you.

 

5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @SH_94 ,

 

we're going to need a lot more information

 

Where do the numbers come from?

What's the logic?

What do the values at the top mean?

 

M.



Bulien

SH_94
11 - Bolide

Hi @mceleavey ,

 

Basically, i would like to combine all the file with the value below from File and File 2 to derive the desired result 

SH_94_0-1634061131371.png

SH_94_2-1634061226289.png

It mean total of 68 +78 extracted from both file will give 147.

SH_94_3-1634061322239.png

For this screenshot below , it does not have any meaning and i plan to remove it using alteryx.

SH_94_4-1634061404097.png

 

 

 

Let me know if my explanation is not clear.

mceleavey
17 - Castor
17 - Castor

Hi @SH_94 ,

I've attached the solution for you.

Basically, you just needed to strip away the unused rows and create a sum.

You can do this more elegantly using the directory input but I don't know if that would be appropriate. You can change the start to do that if you like.

 

Basically, I've pulled them all in, stripped the unused bits and smooshed them together:

mceleavey_0-1634062009782.png

 

This gives you:

mceleavey_1-1634062035319.png

 

And you can drop whichever you want.

 

Hope this helps,

 

M.

 

 

 



Bulien

SH_94
11 - Bolide

Hi @mceleavey ,

 

Thanks a lot for the guidance.

 

I quite impressed on the speed that you build up the workflow within few minutes as normally i need to take few days to complete it.

 

Many thanks again for the support.

mceleavey
17 - Castor
17 - Castor

@SH_94,

Everything is quick with Alteryx! 



Bulien

Labels