Copy values in a column to each record

[JDong]

Dear All,

I have the below table and need to achieve the last  'Sales USA' column

Country	Category	Sub-Category	Sales	Sales USA
USA	Furniture	Bookcases	261.96	261.96
USA	Office Supplies	Chairs	731.94	731.94
USA	Technology	Labels	14.62	14.62
China	Furniture	Bookcases	1900	261.96
China	Office Supplies	Chairs	485	731.94
China	Technology	Labels	350	14.62
Australia	Furniture	Bookcases	445	261.96
Australia	Office Supplies	Chairs	725	731.94
Australia	Technology	Labels	1208	14.62

As we see here the last column is a copy of the USA data. So for every country in my dataset need to repeat and copy the USA data as a column. The category and Sub category columns are constant for all countries.

Do let me know in case of any questions.

Thanks

[JDong]

Hi @atcodedog05 

One more question 😑

What if the sub category list is empty in some lines...in my actual data the sub category is empty for some countries and hence the join does not pull the records ?

Can you please help how to deal with the joins in such case.

So I am not yet getting the desired outcome in the flow.

[atcodedog05]

Hi @JDong 

As a analyst you and your stakeholders need to decide how to handles blank sub category.

One thing you can do is fill all the blanks with single sub category.

Or else let me know how you want handle the scenario. 

[JDong]

ok so..on blank sub categories it just would join based on the category field.

This seems to be a fair assumption.

Please advise

[atcodedog05]

Hi @JDong 

The issue with that is each category has multiple sub category 

[JDong]

Hi @atcodedog05 

So is there any other tool that will help here in Alteryx to copy the values over to other countries ? I guess the join approach may not be suitable since records drop in the filter

Thanks