Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Derive column by copying row values

DigitMac
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
DigitMac
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
16 - Nebula
16 - Nebula

Hi @DigitMac 

 

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?

DigitMac
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

DigitMac
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

DigitMac
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