Derive column by copying row values

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

Datasets

Developer

Developer Tools

Accepted answers

DavidP

Hi @JDong

Would something like this work for you?

calculate sales final.yxmd

All comments

DavidP

Hi @JDong

Would something like this work for you?

calculate sales final.yxmd

ehughes

Hi Gallop,

Are there always two rows for each country? If so, something like this could work:
(I've attached a workflow where you will be able to look at the formulas more closely)

New Workflow3.yxmd

JDong

Hi @DavidP

This is very close to what I need...but only thing is the values are dropped after the join

In my actual case...I have 3 columns

Level 1 | Level 2 | Level 3

Maybe Level 2 and Level 3 have number of blanks and hence the records dropping ?

But I see the values in the derived fields.

How to add back the remaining dropped records after the join ? would union work after join and I do a left join.

Thanks

JDong

Hi @ehughes

Good question..there would be multiple rows for each country. But in all the record set would be limited to a fixed set of rows say 80 rows.

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703