Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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