HELP

I am trying to learn Alteryx. Is there anyone who can help with this one? I am trying to join two files. Both file has primary key "project#". I did that already. but I want to remove those "null" cells and also get total cost for each project number. For example as you can see I have multiple projects which has same project number "1101170010.14030.130" I want get the sum of those project numbers

Developer

Developer Tools

Accepted answers

JWS

Hi rrahman7,

Can you send a screen shot of your Filter tool configuration. Even better, ff you can attach the workflow to your next post, I can take a more detailed look.

JWS

Yes, this is perfect. The issue with the null values occurred since the Project Numbers in the two files did not exactly match when you attempted to join them. To perform a Join the fields in both files need to match exactly. Please see the screenshots below to observer the difference in Project # in both files. I have attached a packaged workflow that leverages the text to column tool to parse the Project # into the right format. I am also using the Join tool to join the two data sets.

Please let me know if that gives you the result that you are looking for.

New Workflow1.yxzp

All comments

JWS

Hi rrahman7,

You can use the filter tool to exclude the "Null" rows. Just drop it into the workflow before the summarize tool and you should be good to go.

DiganP

@rrahman7 you can use the filter tool to filter out the nulls and the summarize tools to group by the project # and sum up the cost.

rrahman7

didn't work for me. If I use filter tool it removes some of my data.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335