Conditional Statement based on Data from Separate Inputs

Question

I have an one CSV with a list of countries and their population (A). I have a second CSV with U.S. states and their populations (B). I'd like to implement a formula that matches states with = or < populations to that country and append that state and state pop information to Tablea A. Here's what I mean:

Example:

Table A:

CountryPopulationAfghanistan2666000Albania10000

Table B:

StatePopulationAlabama1162900Arkansas762600Rhode Island9000

and I want my output to look like this:

CountryState EquivilentCountry PopState PopAfghanistan Alabama2666000 1162900Afghanistan Arkansas2666000 762600AfghanistanRhode Island2666000 9000AlbaniaRhode Island100009000

What is the most effecient way to do this in Alteryx?

RodL · Accepted Answer

Easiest way is to use an Append Fields tool (which basically gives you a Cartesian join of your two data sets).

Then you just add a Filter tool that filters on the basis of the one population field being =< the other population field.

(As a note, in the Append Fields tool, you will need to change the default setting at the bottom of the Configuration so as to "Allow All Appends".)