This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am looking to compare two tables
What I want to do is compare the data from the two sources, to find which fields have matching data such that I can rename the fields from the SQL table to the matching fields in my prepared extract.
Example tables below.
Compare data in top and bottom tables, find matching field names
Hi @Original_Yodies ,
You can do that by using the field info tool located in the developer category.
Take a look at the attached example and let me know if this makes sense to your needs.
One thing missed though is that the datasources do not share field names.
In your example datset 1 has fields a,b,c,d,e.
Datset 2 also has those names plus a few extra f,g,h.
I think this will work if i join not on Names, but on Type/Size
Replying to my own thread. Great....
Finding the Field Summary tool a far greater resource than the Field Info tool for this type of work.
I am gonna have this new database mapped in no time!