Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try this in your load script like
LOAD *,
SUBFIELD(YEAR, '/') AS Year
From Yourtablename;