Find missing fields when comparing QVD's for Concatenate

[ivandrago]

Hi,

I have multiple QVD's that I need to concatenate t o make one fact table, I want to Optimization to work when reloading the Document but at the moment it doesn't work due to the field differences across the QVD's that are being used.

Is there a tool out there or a process to find which fields need to be in the script for each qvd for the reload to be optimized.

At the moment it is very time consuming, as there could be be between 100 and 150 fields per QVD.

Thanks

[swuehl · Accepted solution]

Maybe like this.

[YoussefBelloum]

Simple and efficient