Hello
I am trying to use this feature to create enterprise group: eg - Locations with one or two level hierarchy. But what format of data in the excel sheet need to be followed?
Does anyone can share a working sample sheet ( a few lines of rows) for me to test ?
Thank you in advance.
Best Regards
Kev
Oct 04, 2019 08:16 AM
Hi @Kevin_Hou
See the attached sample fro upload via the data import function in the GUI. It is important to load the parent level first.
Regards
Oct 04, 2019 11:08 AM
By default, the Business Adapter users a "\" to delimit each level of the tree. For example, if you submit a spreadsheet with the following rows:
North America\Canada\Montreal
North America\Canada\Toronto
North America\USA\Chicago
North America\USA\Atlanta
You will have a Location Tree Structure that looks like this:
North America
Canada
Montreal
Toronto
USA
Chicago
Atlanta
Oct 04, 2019 08:30 AM
Hi @Kevin_Hou
See the attached sample fro upload via the data import function in the GUI. It is important to load the parent level first.
Regards
Oct 04, 2019 11:08 AM