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 |
