Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Derive column by copying row values

JDong
8 - Asteroid

Hi All,

 

Please refer to the below sample data :

 

CountryVehicleTypeEngineSalesSales Final
USACarsSedanEngine1500500
USABusDoubleEngine1700700
GermanyCars7SmallEngine267500
GermanyBus4ThirdEngine233700
KoreaBus2 Engine356500
Korea

 

 Engine372700

 

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

15 REPLIES 15
JDong
8 - Asteroid

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
17 - Castor
17 - Castor

Hi @JDong 

 

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

ehughes
9 - Comet

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
8 - Asteroid

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
8 - Asteroid

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
8 - Asteroid

Thanks @ehughes , @DavidP 

 

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

 

 

Labels