Working with FM Pro Advanced 16. I have a csv file that contains data from a registration process where each row is for a unique person, but the row might contain multiple cells of registration data (all in the same row) like course numbers that need to get extracted out into multiple FM records where each record has the name of the person, their ID, and then only 1 single instance of a course number. Some rows in the csv will have multiple course numbers and others will contain a single number. The csv might be something like
|Name||Course 1||Course 2||Course 3|
I want this to become a total of 6 records in FM
I have a layout in FM where I have imported all of the raw data from the csv and gotten the appropriate info to should up in other related layouts, but am having trouble coming up with a solution to create the multiple records from a single row of the csv or creating multiple records from the single record in the layout containing the raw data.
any help is appreciated, thanks.