×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

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

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

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

(OP)
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

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close