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

[atcodedog05]

Hi @JDong 

How exactly is Sales USA is mapped.

[JDong]

Thanks...based on the Country, Category and Sub category.

In my actual flow USA data is a separate source...

[atcodedog05]

Hi @JDong 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[JDong]

Sorry maybe my question was not clear.

I need to derive the last column 'Sales USA'. The Sales column is part of my dataset. As we see the last column is a copy paste of only USA values but for all countries.

Thanks

[atcodedog05 · Accepted solution]

Hi @JDong 

Sorry the column was deselected 😅 I have done the same.

Output:

[JDong]

haha...my bad thanks and this helps !

[atcodedog05]

Happy to help 🙂 @JDong 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[JDong]

Hi @atcodedog05 

An extension to the above question

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

If I introduce new countries later in the flow...how can I copy the same values for other countries ?

Is there an easy way to do this ?

Thanks

[atcodedog05]

Hi @JDong 

The above workflow should even if you add new countries.