Data360 Analyze

Hi all, I hope you can assist me.

I'm trying to add a numbered index column to my data.

I have had no luck with finding an option to do this with the vanilla nodes or with Python.

Has anyone been able to do this?

Any assistance would be appreciated.

You can do this in a Transform node with some Python scripting.

The ConfigureFields script is executed once when the node is run and this happens before the first record is read/processed.

The metadata and initial value of the counter variable used for the index (Rec_ID) is defined in the ConfigureFields script.

Using the ProcessRecords script, the counter value is output and then incremented for each input record.

Hi Adrian.

This worked perfectly!

Thank you very much for your assistance.