topic Re: Level 2 Sprint 1 - Lesson 1.3.3 Import Data into Region Flat list in Academy & Training https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100116#M2824

@ankitaga2000 , the Region Name is the name of the list item so it should be mapped to the Region Flat instead of Parent

 Fri, 05 Mar 2021 09:19:49 GMT andre.lie 2021-03-05T09:19:49Z Level 2 Sprint 1 - Lesson 1.3.3 Import Data into Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100107#M2823

Hi All,

 

I am not able to import the flat file into the Region. Please help. Attached are the screen shots.

ankitaga2000_0-1614929641739.png

 

ankitaga2000_1-1614929669881.pngankitaga2000_2-1614929690155.png

 

ankitaga2000_3-1614929720739.png

 

It says 0 updated.

Please help.

 

Regards,

Ankita

 Fri, 05 Mar 2021 07:35:50 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100107#M2823 ankitaga2000 2021-03-05T07:35:50Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100116#M2824

@ankitaga2000 , the Region Name is the name of the list item so it should be mapped to the Region Flat instead of Parent

 Fri, 05 Mar 2021 09:19:49 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100116#M2824 andre.lie 2021-03-05T09:19:49Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100232#M2826

Thank you so much

 Sat, 06 Mar 2021 03:48:57 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/100232#M2826 ankitaga2000 2021-03-06T03:48:57Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/123904#M3466

is this what the final result should be in the gridview?

 

ninja247_0-1635957053346.png

 

 Wed, 03 Nov 2021 16:31:19 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/123904#M3466 ninja247 2021-11-03T16:31:19Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145899#M5920 < P >请帮我确认更新的地方Region code after Region Name.

 Tue, 30 Aug 2022 02:40:34 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145899#M5920 nehabishnoi20 2022-08-30T02:40:34Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145902#M5923 @ankitaga2000
Please help me and confirm where to update the Region code after importing Region Name. Thanks Tue, 30 Aug 2022 02:47:16 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145902#M5923 nehabishnoi20 2022-08-30T02:47:16Z Re: 2级Sprint 1 -教训1.3.3导入数据to Region Flat list https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145915#M5926

@ankitaga2000 

Hi

 

The key to importing to lists is understanding the data in the source file and where it go in the target list.

 

Here the source file has region names and region codes.

 

The target lists is a flat list - flat lists dont have parents assigned to them.

 

Therefore the region name maps to region flat and region code maps to code; no parent is required.

 

Please try this.

 

Ravinder.

 

 

 Tue, 30 Aug 2022 07:21:02 GMT https://community.anaplan.com/t5/Academy-Training/Level-2-Sprint-1-Lesson-1-3-3-Import-Data-into-Region-Flat-list/m-p/145915#M5926 RavinderB 2022-08-30T07:21:02Z