How to compare Metadata of 2 datasets

Environment Details:
Alteryx Designer: 2022.1

Alteryx Server: 2022.1

Hi Community,

I am trying to compare the metadata of 2 datasets with many fields, 105 to be exact, and I want to see which fields have changed and which have retained the same data type. How do I go about it? Below is an image of the workflow for your reference.

Any leads would be appreciated.

Comparing Metadata.png

Workflow

Datasets

Data Investigation

Accepted answers

nagakavyasri

Datatypes comparison.yxmd

All comments

binu_acs

@Danial_Nawab Field info tool is an option for your use case

MEtadata_Compare_010823.yxmd

Felipe_Ribeir0

Hi @Danial_Nawab

I dont know if you already tried this, but there is a tool called 'Field Info'. This tool will bring the information to the workflow as data, so you can compare/store or whatever you need with it.

Danial_Nawab

Hi @Felipe_Ribeir0 and @binu_acs,

I have a number of fields that I would like to compare side by side with respect to their data types. I tried using the Field Tool but it doesn't seem to help me achieve what I want. An image is attached for your reference which contains all the variable names under the 'Name' column followed up by 'Type' which contains their respective data types. I want to achieve an output where I can have all the variable names(present in the 'Name' column) listed side by side with their data types before and after manipulation.

Field Description.png

nagakavyasri

Datatypes comparison.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703