Help loading tables

[#1]

Hello.

I have an excel file that contains a lot of sheets, each one with one table. The problem is that I can´t load all my tables, because is I loaded the tables commented in the script, then the table P6 doesn´t load well the data.

I don´t know why, anyone can help me???

I attach the excel and qv files.

Regards

[swuehl]

What do you mean with "then the table P6 doesn´t load well the data."?

I noticed that some of your tables share more than one common field name. As you probably know, QV is automatically linking tables by common field names, and if more than one field name is common between two tables, QV will introduce a synthetic key table.

This is what you got, a huge synthethic key. I don't think that's what you want, though. So you need to go over all tables and decide which fields to load (don't just use star symbol to load all fields in) from which table.

You can rename fields, if appropriate, to load the data in, but avoid linking on these fields.

Hope this helps,

Stefan

[#3]

Thanks for the answer, it was very helpful

The problem was that some field apears combined with others in some tables and alone in other ones. I agruped always that fields and it works.