@fleb thank you so much for your help, that worked beautifully!
Hi @bansalpeeyush29 thank you for your reply. If I'm reading your response correctly, I am already doing just that. I have added both of the sources to the dashboard and mapped the key ID fields from the 2 sources to the same variable field as seen below: ! [Instructor ID] comes from the uploaded file and EMP_ID is an embedded data field from the survey, and I mapped them both to the variable named "Instructor ID" for the sake of simplicity. As I said, though, this is producing a 'union' rather than a 'join'. Looking at the records for 001084901 as an example, for which I populated the survey with test data, the uploaded dataset has 12 records. After mapping the two datasets based on that field, I end up with 13 records: 12 for the uploaded, and one for the survey, evidenced below by how the data is written as N/A for survey fields on uploaded records, and vice versa. ! My thought is that if it were a true 'join', I'd see the original 12 records from the uploaded dataset only, wit
Hello @Shashi Thank you very much for your reply! That makes a lot of sense. I'm a newbie at JS but your response at least gave me the place to start. I'll do further research into using Select and start putting the code together (hopefully). Thank you again!
Gotcha, thanks @TomG . I am a completely newbie when it comes to JS. Is there a resource that might be able to point me in the right direction with the matter? Thanks again!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.