How to Create a unique Id despize identical rows

[Antoine553]

Hello,

I'm trying to display some data from an xlsx file on a scatter chart. I realised that many data are displayed on my Table Box exactly as it should but not on my chart. I think that i should create an unique identifier for each data and count them in my chart to display it correctly (X,Y,Count(Id)). I tried RowNo, RecNo, autonomber but i always have many identical identifier and can't have my unique identifier.

LOAD    Numero_Agent,
                Nom_agent,
               Gare_d_entree,
               Gare_de_sortie,
               Montant_TTC
FROM listing_peage.xlsx (ooxml, embedded labels);

Is it having issue because other tables are related to this one ?

Can someone please help me create an Id for the Table loaded above.

Thanks and sry for bad english.

[FakeJupiter · Accepted solution]

Hi,

Which fields contain the values x and y to be evaluated in the scatter chart?

And why were you not successful with autonumber()? What issue did you have?
I would just add autonumber line with the dimension fields to your script, for instance:

autonumber(dimension1&dimension2&dimension3&dimension4) as customKey