TheunE

Excuse me for asking another dumb question, but what do you mean by FileMaker will only import one record per unique ID? Will it import all variables and put them in one record or will it only import one variable each time? For clarity purposes I added an example of what I have now. Under that is the structure I would like to have in FileMaker. example.txt

Thank you for your reply. However, I don't want the other records to be deleted. Consider this example: ID___ YEAR VARID VALUE ID001 2009 VAR001 10 ID001 2009 VAR002 15 ID001 2010 VAR001 12 I would want all these variables to merge into one ID001 record. Could you please tell me how this is possible in FileMaker?

Hello, I have just started working with FileMaker, so forgive me if this is a dumb question. My problem is the following. I have got a massive excel-file with 5 worksheets. The columns are aligned as follows: - A unique ID number - A variable ID (such as ROI for return on investment) - A year - The value of the variable for that specific year and ID Now what I want is that for every unique ID, one record will be created in FileMaker. Problem is, that in excel there are up to 90 rows for every unique ID for a different variable/year. Can anybody help me with this problem?