Issue in import subcategory with category from excel into staging table

[rahul gupta6]

Hi,

I am trying to import an excel sheet into incident table with category and subcategory columns using import set.

While importing the data in staging table, the subcategory value is different than expected.

In staging as well as Incident table, there are category values as 

label                       Value

category1              category_1

category2              category_2

category3              category_3

Subcategory label and value as

subcategory          subcategory_1 (pertains to category1)

subcategory          subcategory_2 (pertains to category2)

subcategory          subcategory_3 (pertains to category3)

The excel sheet has category as category1 and subcategory as subcategory(subcategory_1). But when I upload the excel in data source and do laod data, the value in subcategory column in staging table is subcategory_3.

Can anyone help with this.

[Mark Manders]

Without knowing your transform map and what it is doing, it's difficult to give an answer. You give us the input and the result, but we are missing the information about what is in between.