Hi. I have two data elements in a loaded table that if in excel I would have concatenated into a new column in the table and then added an additional column to flag a criteria.
Element 1 = TaskID (multiple records in the table)
Element 2 = Type (can be multiple values per TaskID)
Added Element 3 = TaskID&Type
Desired Element 4 = flag as Y/N if the record has the a matching Element3 in the table with the record's TaskID& a text string Type as manually selected
Any suggestions on how to create data load editor? Thanks!