In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Re: removing null values in columns

utsarunner981
8 - Asteroid

hi everyone! thanks for your help! this is what i am trying to accomplish.

 

dataset1: 

Product ID

name

price 

1001

table

 $ 100.00

1002

sofa

 $ 250.00

1003

chair

 $   40.00

1004

loveseat

 $ 150.00

1005

bed

 $ 300.00

1006

mattress

 $ 100.00

 

dataset2:

Product ID

Date Sold

1001

10/31/2021

1004

11/3/2021

1006

11/1/2021

 

dataset3:

Product IDnameshipping
1001tablecalifornia
1002sofaoklahoma
1003chairtexas
1004loveseatcalifornia
1005bedtexas
1006mattresstexas

 

dataset4:

Product IDnamepriceDate Soldshipping
1001table$10010/31/2021california
1002sofa$250 oklahoma
1003chair$40 texas
1004loveseat$15011/3/2021california
1005bed$300 texas
1006mattress$10011/1/2021texas

 

sample workflow: 

untitled.PNG

1 REPLY 1
ChrisTX
16 - Nebula
16 - Nebula

Would this work for you?  (guessing Dataset 4 is your desired output)

 

ChrisTX_0-1637006355641.png

 

 

Chris

Labels
Top Solution Authors