How to duplicate records

[mpfariseni86]

Good day all,

I have a question. I have a table of unique CaseNo, the Client is providing Year column data separated by a backslash. I am trying to replicate the rows only where the year field is separated by "/ ". I have a requirement to provide a Count of all previous nsi by Year.

I have provided a sample table

Thank you in advance.

Regards

Mpfariseni

CaseNO	Previous NSI	Previous_NSI#	YEAR
DD001	YES	2	2016/2017
DD002	YES	2	2017/2018
DD003	YES	2	2009/2011
DD004	YES	1	2017
DD005	YES	1	2018
DD006	YES	1	2016

[vishsaggi]

Try this in your load script like

LOAD *,

           SUBFIELD(YEAR, '/') AS Year

From Yourtablename;