add new ways to split optional id column and data