Transforming data profiling results

[njvitale421]

Hello, I am new to the tool and the forum. I did some searching for similar cases and didn't come up with the anything. I do apologize if this has already been answered elsewhere. Thanks in advance for any assistance.

I have done a basic data profiling workflow in Alteryx and now I am looking to make the results more usable. I have acquired the basic profiling results (I'm sure most of you are familiar with this output), but what I would now like to do is convert make “Name” into separate columns and have the corresponding “Value” in each column. This will make it easier to consume.

End state would be one record for Field Name, all “Name” values (Shortest Value, Count Unique, Field Type, etc) would become separate columns and the corresponding values from “Value” would populate those columns.

Field Name	Shortest Value	Minimum	Maximum	Count Unique	Unique Values	Field Type	Field Size
Document Type	Filed Form	Fact Sheet	Non-Filed Form	3	Fact Sheet	Value	Value
Release	Value	Value	Value	Value	value	value	value

[jmh8981]

I referred this for my query and it works fine . Thank u.