Ignore case in load script dimensions

[Anonymous]

Good day!

In attached model i load data from two xlsx files (Source1, Source2)

Source1 and Source2 have the same field Name, by which i want to connect data.

But after reload filed Type is loading only for Name DSD.

How to do this with ignoring case?

Thank you!

[maleksafa]

use Upper or lower function when loading the field name

Load

     Upper(Name) ...

[maxgro · Accepted solution]

use Upper or Lower or Capitalize in your load

Capitalize(Name) as Name,

[Anonymous]

Good)!

Thx