MENU
An Administrator received an export file from an external system, which contains products and categories. The categories are delimited using a single pipe character.
In which two ways can the Administrator set this up for import using the CSV import tool?
Suggested Answer: C, D
Get Premium AP-201 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
When setting up categories for import using the CSV import tool with categories delimited by a single pipe character, the Administrator canC. Split the categories into separate columns with appropriate labelsorD. Replace the pipes with a forward slash. Both methods organize the category data in a format that the import tool canrecognize and process effectively.
6 comments · newest first
LA
Lavonne
10 hours ago
A and B don't make sense for this.
CA
Carman
6 days ago
C is definitely the way to go!
CU
Curt
11 days ago
I definitely remember that splitting into separate columns is a common method, but I’m unsure about the other options.
PE
Percy
16 days ago
I feel like adding a dash to the category column might not be the right approach, but I can't recall why.
HE
Herminia
21 days ago
I remember practicing a question about delimiters, and I think replacing the pipes with something else could work too.
TI
Timmy
26 days ago
I think we might need to split the categories into separate columns, but I'm not sure if that's the only way to do it.