• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

XML / CSV Data Manipulation

I have 4 separate sets of data, each in 3 formats (.csv, .xml & .xls) and 1 excel spread sheet which contains a complete dump of a supplier's product list (over 35,000 items), the other 4 data sets contain the following information for each specific item contained within the product list dump:-

- Styles
- Icons
- Image filenames
- Descriptive data

The separate data sets can be linked together using a "style ID" which is replicated across each data set, I would like to link all data together and ensure the data is matched to the correct product.

The method I'm currently using (from within MS Excel) is to dump all data in to one "master" spread sheet and use the VLOOKUP function to pull back the relevant values. Although this is useful, it's still extremely laborious to perform for over 20,000 product ID's on 35,000 items.

The process needs to be automated and some products share the same style ID (e.g. 20 T-Shirts have style ID ABC1234, information for Style ID ABC1234 is stored in separate spread sheet and has adjacent cell containing description for product).

--------------------------------------
EXAMPLE
--------------------------------------

I need formulae / functionality to do the following:-

- Lookup style ID
- Pull back descriptive data contained in adjacent cell and dump into specified cell reference
- Move on to next style ID and perform same action in loop

Also, the style ID's have no sequential order, they are a numeric/text mixture and I'm unsure how to automate this as Excel has no way of knowing which style ID to move on to next as they are custom values, as mentioned above there are over 20,000)

What's the easiest / most automated way or achieving this?

Cheers,

Craig
0
mparfitt
Asked:
mparfitt
1 Solution
 
Ray PaseurCommented:
Please reduce the data sets to about 5-10 data elements and post the data, in the form of the SSCCE.  We can probably show you the principles that will be applicable to the larger data set.
0
 
mparfittAuthor Commented:
Please mark this thread as closed as I have now spotted my mistake.

Thanks for your time.
0
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now