Complex file - cleaning is needed

[SH_94]

Hi community,

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

Original file

Result Desired

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

Thank you.

[mceleavey]

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]

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 

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

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

Let me know if my explanation is not clear.

[mceleavey · Accepted solution]

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:

This gives you:

And you can drop whichever you want.

Hope this helps,

M.

[SH_94]

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]

@SH_94,

Everything is quick with Alteryx!