Alteryx Designer Desktop Discussions

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

Remove Null to make 1 Single table

EmilDem01
8 - Asteroid

How can I eliminate null values from cells to consolidate them into a single table in Alteryx?

 

Sample Input 

Don.Bosco School     
RecordNameMarksSixthNameMarks
1Shruti100Fifth[Null][Null]
2Elaine80Fifth[Null][Null]
3Nethra60Fifth[Null][Null]
4John 60Fifth[Null][Null]
5Max50Fifth[Null][Null]
6[Null][Null]SixthShruti90
7[Null][Null]SixthElaine80
8[Null][Null]SixthNethra50
9[Null][Null]SixthJohn 60
10[Null][Null]SixthMax55

 

Sample Output 

RecordNameMarksSixthSchool Name
1Shruti100FifthDon Bosco
2Elaine80FifthDon Bosco
3Nethra60FifthDon Bosco
4John 60FifthDon Bosco
5Max50FifthDon Bosco
6Shruti90SixthDon Bosco
7Elaine80SixthDon Bosco
8Nethra50SixthDon Bosco
9John 60SixthDon Bosco
10Max55SixthDon Bosco
7 REPLIES 7
Raj
15 - Aurora

@EmilDem01 
find the workflow attached

mark done if this is solved.

vizwithdan
8 - Asteroid

Hi @EmilDem01 ,

 

The solution for this is attached :)
Please mark as complete if this has resolved your query.

Thanks

Danny

EmilDem01
8 - Asteroid

Hey Danny,

 

Thank you for providing the workflow. I have some additional data to incorporate.
Could you please provide the formula needed to update the tool in order to achieve the desired output as described below?

 

vizwithdan
8 - Asteroid

Hi,

You can use the same logic in the Formula tool of the original solution I provided.

They are just IF statements to say if one column is null then take then take the original value and if not take the new one :)

It'll be worth you digging through my original solution in order to learn how to complete next time....learning is winning! 

Thanks

Danny

EmilDem01
8 - Asteroid

yeah i used the same solution, but i keep getting the Parse Error.. ive been trying since a while - so reached out

EmilDem01
8 - Asteroid

Got the clue in ur reply - worked 

IF ISNULL([New Column]) THEN [Original Column] ELSE [New Column] ENDIF

vizwithdan
8 - Asteroid

The the key to it yes!
Please can you mark as the correct answer so I get my Kudos :) 

Thanks You! 
Danny

Labels