For further processing I am to export manager data into spreadsheet.
My export procedure-
Customers > Batch Update > Download the .tsv file
Normally, the key field is the right-most field in the .tsv file.
But, there is a problem with some customers. Instead of one row, some (many) customers have two/three rows of data.
The right-most fields are Custom Field & Key Field
1. When data spits into two rows-
Custom Field Value goes into “C” cell & Key value goes into “D” cell in the second row.
2. When data splits into three rows
Custom Field Value goes into “C” cell in the the second row
& Key Value goes into “B” cell in the third row
Now, I have to update my 2000+ customers data. Actually I am assigning different “Control Account” to customers.
I am afraid, these extra rows will cause problem when updating.
Another thing I noticed, If I assign a control account to a customers, in the .tsv file, it shows some values like the “Key” field value instead of showing the control account name as text.