We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

Complex file - cleaning is needed

SH_94
9 - Comet

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
16 - Nebula

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.

SH_94
9 - Comet

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
16 - Nebula

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.

 

 

 

SH_94
9 - Comet

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
16 - Nebula

@SH_94,

Everything is quick with Alteryx! 

Labels