This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
I would like ask how to clean and amend the workflow to produce the result as below:
Could you anyone guide me on how to produce the result above based on the samples format given?
Go to Solution.
Go to Solution.
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?
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.
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,
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.
Everything is quick with Alteryx!