AnsweredAssumed Answered

Field value that counts occurrences of an ID

Question asked by samuele.vigano020435 on Jul 19, 2016
Latest reply on Jul 21, 2016 by Srinivas Chandrakanth Vangari

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?