Hello everyone,
This is probably elementary, but I'm losing the last of my hair. I'm new to Data360 Analyze and cannot for the life of me figure out how to reference data between records. I have a field with Submit Date (datetime) and a handful of records. What I need to do is create a new output that looks at the Submit Date from record 1, and compare to record 2. 2 to 3. 3 to 4. So on and so forth. Coding wise, I understand how to make this happen (I think) except for one very simple thing: I don't know how to reference record 1, 2, 3, so on and so forth in my code. It's easy as pie to compare data in a record, but I have no idea how to do between records.
Any help would be greatly appreciated.
------------------------------
Daniel Pisani
Knowledge Community Shared Account
------------------------------