on 01-26-2007 4:58 PM
Hi,
I am populating data in the main table(Customer) along with its qulaified table(Sales Data) through Import manager-sp4.
I am finding there is some inconsistency in loading sales org data where most of them populating all the required fields of a customer , few customer row not populating all the fields of Sales data.
I have checked the input file and found one customer has two sales org but in Datamanger it is showing only one sales org connected to its customer.
I tried to load the fie again using the same input file with Configuration option
Default multivalued:Replace
Default Qualified:Replace
Default matching:All
and in Main table , the said Qualified is set to "Set Qualified update" to Replace.
But it is failing to replace and connect all fields with the main table row.
Appreciate suggestion and feedback
regards,
-Reo
Hi Reo
I think the issue is with the Set Qualified Update option.
- If you set to the Replace then you may need to add one of the specify a matching qualifier.
-Like wise you could use the Update option, Set to Sales Org. as you matching qualifier and then set New link: Create, Existing Link: Update ~(all mapped Qualifiers). This will create or add new qualifier based on the matching of the sale org. value.
- Last you could use the Append option to add a new entry to your qualified look table. but be careful that you do not repeat existing entries
Hope this helps
C
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I could get it by Replace in Config option and "Update all map fields" in matching.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.