Jump to content

Combine multiple columns into one


This topic is 2244 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Import the source data 3 times. The first time, import the first three columns into their corresponding fields of the target table and FIELD1 into FIELD99. For the second import, keep the same mapping except this time map FIELD2 into FIELD99. The third time, import FIELD3 into FIELD99 - again, together with the first three columns.

 

Edited by comment
Link to comment
Share on other sites

Whoa, we need to regroup here.

First, "data structure" is defined by tables and fields. When you are talking about "changing the data structure", you are perforce talking about moving the tenant data to a new schema to house it.

Next, the original data structure that you show us is not normalized. We don't know what this data represents, but in order to process it you will very likely benefit by restructuring it to its normalized form. Note that your second structure is not fully normalized either.

Finally, if your question is about charting the existing data, then ask about that - and explain what exactly the chart should show. I would also suggest using meaningful names instead of a completely abstract example - it makes it much easier to understand the situation.

 

21 minutes ago, jagstirling said:

I want to get the 3 fields into 1 filed

Not exactly; you also want to get three records for each existing record.

 

Edited by comment
Link to comment
Share on other sites

This topic is 2244 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.