topic Re: Accounting for missing Values & Transposing Data in Alteryx Designer Desktop Discussions

Accounting for missing Values & Transposing Data

suds144 — Wed, 09 Feb 2022 17:22:06 GMT

Hello everyone,

I'm trying to account for missing data. This is my output

My output should be:

I've tried using the transpose and Filter function but am not getting the desired outcome. Thank you!

atcodedog05 — Wed, 09 Feb 2022 17:24:45 GMT

Can you please provide this data in an excel file.

Happy to help : )

suds144 — Wed, 09 Feb 2022 17:27:10 GMT

Thank you

atcodedog05 — Wed, 09 Feb 2022 17:29:22 GMT

Here is how you can do it.

Workflow:

Hope this helps : )

Akash__on — Wed, 09 Feb 2022 18:15:00 GMT

If you have data like this 👇 (as i am having it)

Then

1) use cleansing tool to replace any trailing or leading spaces.

2) use transform tool

3) use filter [value] !="Null"

4) Select tool to only use required fields

I hope this helps :)

suds144 — Thu, 10 Feb 2022 10:22:30 GMT

Thank you so much!

suds144 — Thu, 10 Feb 2022 10:23:50 GMT

Thank you so much! So helpful!

atcodedog05 — Thu, 10 Feb 2022 10:26:27 GMT

Happy to help : ) @suds144

Cheers and have a nice day!