How to distinguish identical records

[#1]

Hi

my dataset contains 2 fields with some occurrences of identical record pairs. During the upload of the file I need to concatenate a counter to distinguish identical records. Attached is an example of the load file (columns A and B) and the desired outcome.

What is the correct code to obtain this?

Thanks for your help.

Pat

[MarcoARaymundo]

Try

LOAD DISTINCT

  A,

    B

FROM (ooxml, embedded labels, header is 1 lines, table is Sheet1);

[swuehl]

LOAD *, Intermediate & '_' & (AutoNumber(recno(),Intermediate)-1) as Requested;

LOAD *, A&'_'&B as Intermediate;

LOAD floor(A) as A,

     floor(B) as B

FROM

[data.xlsx]

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, Pos(Top, 1))

));