I have defined a mapping between a CSV and a XML profile. The XML profile is obtained by a Successfactors connection in UPSERT mode. A field of this XML profile, named "seqNumber", is defined in the following way:
- If there is only a single record associated to a certain userID in the output table, then also seqNumber is 1;
- Otherwise I need to have a progressive list of seqNumbers, starting from 1, associated to the first record in the table with that userID, to the number that is the number of records in the table with that userID.
How can I implement it?