Derive column by copying row values

[JDong]

Hi All,

Please refer to the below sample data :

Country	Vehicle	Type	Engine	Sales	Sales Final
USA	Cars	Sedan	Engine1	500	500
USA	Bus	Double	Engine1	700	700
Germany	Cars7	Small	Engine2	67	500
Germany	Bus4	Third	Engine2	33	700
Korea	Bus2		Engine3	56	500
Korea			Engine3	72	700

I need to derive in a flow the last column. The last column is based on the USA data. We just need to fill in the USA data accordingly for Germany and Korea.

Sometimes the data in Vehicle and Type would be missing, but still the data  is to be derived in last column. Any idea on the logic to be used here.

Please note that my filters would work on the 'Engine' field

Thanks

[JDong]

Hi @ehughes 

Here what I notice is in the first column filter is hardcoded to USA.

Now as per my previous post , I have 3 levels with different values.

Any thoughts how I can handle the filter in the flow you shared ?

Thanks

[DavidP]

Hi @JDong 

It would be best if you can share more representative data.

[ehughes]

Hi Gallop,

Do you want a column for each country? Or do you want the user to be able to select which country to copy to the final column?

[JDong]

Hi @ehughes @DavidP 

Thanks for the reply.The derived column will be in the last column and will have all country information. I want to provide user ability to use filter when I eventually build a front end.

Please let me know on any questions.

thanks

[JDong]

Hi @DavidP 

Yes you are right...the join and union do not work since my data has null records.

Any other way to work this out ?

Thanks

[JDong]

Thanks @ehughes , @DavidP 

I have populated the Null or blank records with data from the previous column and the solution works perfectly well !