This content has been marked as final. Show 2 replies
I would do something like this:
DATA: LOAD * Inline [ 'FirstName' 'Jean', 'Claudia', 'Van Damme', 'Claudia' ] ; DATA2: LOAD *, AutoNumber(RowNo(), FirstName) AS 'DupeCount' RESIDENT DATA ; DROP TABLE DATA ; EXIT Script ;
I got this information from here:
Also, I'm not sure how the RowNo() interacts with the AutoNumber function in the least.