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]

Ah I mean...the new countries are added after the final result using another join.

When we consider the result as shown above is there a way to copy the values to all countries like last time ?

Thanks

[atcodedog05]

Hi @JDong 

Here is an example working for new data set

Output:

Hope this helps 🙂

[atcodedog05]

Hi @JDong 

Suggestion would be add the data at begin itself instead of working after join😅

[JDong]

Hi @atcodedog05 

The problem is data is from a separate source

So the 2nd source has only these records

Country	Category	Sub-Category	Sales	Sales USA
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

And the result of current flow is 

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

Considering this to be the current output is there a way to copy the values to other countries.

I understand you telling me about the fixing the data initially but this input is more like adhoc and the countries list changes every week, but values need to me copied over dynamically. 😀

Thanks

[JDong]

Hi @atcodedog05 

Thanks.

So I am not able to join the data before since in the flow this input is dynamic on a weekly basis

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

So after this join in the end of the flow we get this

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

Is there a way from here to copy the values based on the countries which is dynamic ?

Thanks

[atcodedog05]

Hi @JDong 

Does the new table/values have sales. If it doesn't how is the sales considered.

[JDong]

Hi @atcodedog05 

Only the Sales USA column needs to be populated.

Sales is empty in the data for now. But anyway the Sales USA is an independet column where Sales for USA are copied.

Thanks

[atcodedog05]

Hi @JDong 

Would something like this do.

Workflow:

Output:

Check and let me know🙂

[JDong]

Thanks a lot...I will try and read data before in the flow and get back in case of anything.

Great solution ! 😀

[atcodedog05]

Sure definitely 🙂 @JDong 

Happy to help 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂