I currently have 2 Data Extensions that are being imported via FTP into Marketing Cloud.
DE1 contains user information with a primary key Vehicle_Model_ID. DE1 is used to collect the profile attributes of people submitting their requests for a test drive, so it also contains their email addresses. This is a people-focused Data Extension.
DE2 contains vehicle information with a primary key Vehicle_Model_ID. DE2 contains information about the vehicle like it's make, model AND it contains the information about the 3 recommended vehicles that "match up" with the vehicle. This is a data extension containing vehicle information.
What I was going to do was create a data relationship between DE1 and DE2 - so I could create a data filter out of the combined fields across both these tables, run the filter every day and dump the results in DE3. Now if this can work, how can I extend the code that we already wrote up for a single lookup to automatically pick up the Model_ID? That's the ONLY missing piece I guess.
We can figure out the rest of the code to fetch data about the Recommended Vehicle 1, Recommended Vehicle 2 and Recommended Vehicle 3 - and create the content block around each of them. Please tell me that I won't have to write a line of code that contains 480 items in it - as we have a list of 480 Vehicle_Model_IDs.