When we try to import data into a staging table using xls import using 2 different data sources it will create 2 different import sets(Importset1 and Importset2). After we transforming the data using the 2 different transform map at the same time from 2 different browsers, both these transform maps processing only the latest import set(importset2). Importset1 status is showing always loaded.
Even though we used 2 different transform maps to transform the 2 import sets, Transform maps always use the latest import set to process because both the import sets are stored in the same import set table.
- Use 2 different import set tables to import data and process the data using the transform map
- If we import data into single import set table, if we want to transform both the import sets while transforming the data select import set you want to transform
Please refer Transform map documentation :