How to Create a unique Id despize identical rows

Antoine553 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to Create a unique Id despize identical rows

FakeJupiter — Wed, 30 Sep 2020 07:28:16 GMT

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

topic Re: How to Create a unique Id despize identical rows in QlikView

How to Create a unique Id despize identical rows

Re: How to Create a unique Id despize identical rows