Hello,
New to forum, and new or rather back to some database stuff.
And sort of things I used to find easy it seems now baffle me due to neglect (
I have an odata source that has been published to me containing what is multiple tables with a single table in common.
This results in the single table being occupied consistently.
However all the rest of the data is "stepped".
So instead of having it all normalised into one field (where is the same data for different assets, which means they have output it as separate fields
IE ASSET_CODE/B1_RISK/E1_RISK
In Xthousands recorda Asset Code and B1_RISK is occupied
The for the next Xthousand records Asset Code and E1 is occupied
How do I go about getting Asset_Code and Risk(Normalizing B1_Risk and E1_Risk) so that the SAME field is occupied in an output table?
Be aware there is about 30+ fields for each "table" they have done this with.
And about 16 tables. =(
Help! Please )
Lidias13
New to forum, and new or rather back to some database stuff.
And sort of things I used to find easy it seems now baffle me due to neglect (
I have an odata source that has been published to me containing what is multiple tables with a single table in common.
This results in the single table being occupied consistently.
However all the rest of the data is "stepped".
So instead of having it all normalised into one field (where is the same data for different assets, which means they have output it as separate fields
IE ASSET_CODE/B1_RISK/E1_RISK
In Xthousands recorda Asset Code and B1_RISK is occupied
The for the next Xthousand records Asset Code and E1 is occupied
How do I go about getting Asset_Code and Risk(Normalizing B1_Risk and E1_Risk) so that the SAME field is occupied in an output table?
Be aware there is about 30+ fields for each "table" they have done this with.
And about 16 tables. =(
Help! Please )
Lidias13
