SOLVED
Removing Null and align the data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
DiyaR
8 - Asteroid
‎08-14-2020
11:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx experts,
I tried multiple ways to achieve but no success... Can anyone please help. I am in last step of cleaning the null value in my Alteryx flow.. I am trying to combine
Right_Date | Code | Group | Mask | Disc |
8/14/2020 | 1 | B | [Null] | 10% |
8/14/2020 | 1 | B | BXXX | [Null] |
8/14/2020 | 4 | C | BSSS | 20% |
8/14/2020 | 4 | C | BSSS | [Null] |
8/14/2020 | 2 | A | BCCC | [Null] |
8/14/2020 | 2 | A | BCCC | [Null] |
Output should look like:
Right_Date | Code | Group | Mask | Disc |
8/14/2020 | 1 | B | BXXX | 10% |
8/14/2020 | 4 | C | BSSS | 20% |
8/14/2020 | 2 | A | BCCC | 0% |
Much appreciated!
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
2 REPLIES 2
ImadZidan
12 - Quasar
‎08-14-2020
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @DiyaR ,
Something like this?
I did not pay much attention about the data types. as I am not sure how you are getting the data.
This will give you an idea, I hope.
‎08-14-2020
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you :).. It gave me an idea and it worked as expected..Much appreciated 🙂
