How to standardize values across 2 datasets before comparison?

[ShantanuDagar]

Is there any way to standardize values across 2 datasets.

Like SD in 1st dataset in column A while Standard deviation in 2nd dataset in column B.

(225: As Indicated) in column N in 1st dataset while (225) in column N in 2nd dataset.

And so on...

[ShankerV]

Hi @ShantanuDagar 

Can you please share some example...

[gautiergodard]

Hey @ShantanuDagar 

One way you could consider doing this is by creating a mapping table of names, and using a dynamic rename tool to standardize the names.

Attaching an example based on the information you provided in your post. If you need something a little more dynamic, the dynamic rename tool also allows you to leverage formulas which could be helping to you.