Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Odata contains fields from multiple tables in single table with different field names - for same

Status
Not open for further replies.

Lidias13

Technical User
Sep 5, 2019
2
0
0
GB
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
 
Hi Lidias13 and welcome to tek-tips.

Can we assume you would like to normalize a table with repeating groups of fields? If this is the case you can use a union query. For specific assistance, we would need some actual table and field names.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top