Auto generated Longitude_Latitude field not appearing as option in Location field

[PaoHL]

Hi, 

I'm following along the Data Architect Learning Plan. I am currently in section 'Understanding the Data Modeling User Interface', in the subsection 'Introduction to the Data Manager'. From this section, the video titled 'Geodata Derived by the Data Manager' shows how the Data Manager recognizes existing Longitude and Latitude fields from data added to the app, and creates a new field called 'Longitude_Latitude' with the syntax needed for map visualizations. So far, so good. I can see this generated field in my table too.

Then, the video shows how this new field can be applied to a map visualization. After creating a new sheet, adding a map to the sheet, creating a new point layer and adding 'Customer' as the dimension in the 'Data' property of the map (on the right panel), the video instructs to click 'Location' and use the arrowhead to search for the generated field 'Longitude_Latitude'. Here's where I'm stuck. This field does not appear under the list of fields. See below what I get:

As opposed to what I'm supposed to get (from the training video):

How can I fix this issue?

Thanks in advance!

[PaoHL]

I uploaded all sheets in the xlsx. But the column ‘Longitude_Latitude’ that I’m talking about is in the table/sheet ‘Customers’. I’m attaching a screenshot underneath.
PS: The file path to the xlsx under the name of the table ‘Customers’ looks like that because I’m following along using the Qlik Sense Training environment of my employer, whose instruction is to not upload the training files, but rather use the files which are already saved to a folder that has been pre-loaded by them to the Training Hub.
[cid:image001.png@01DB23DE.4AC86300]

[Alan_Slaughter]

Hi PaoHL, I am sorry but I do not see any image attached. I am using the files located in this zip file:

IntroDataManager_ExampleFiles.zip

[PaoHL]

Hi Ala, thank you for your continued support. The files from the zip file you referenced are available already in a folder on the Qlik Sense Training Hub of my company.

I am using the excel file InternationalApparelData.xlsx, which has the worksheet "Customers". I selected that sheet along all others when I added data to my app via the Data Manager.

I'm attempting to reattach the image from my previous message.