Error when I want to import data based on prefilled table.

40 views
Skip to first unread message

Zizi

unread,
Feb 2, 2018, 4:25:28 AM2/2/18
to pygrametl-dev
Dear All,

I have a dimension table which is prefilled and I want to import data inside the fact table. In my dimension table I have validfrom and validto which is updated manually. when I use dimension.lookup I got this error: 

TypeError: ('Could not join values into a single string. A nullsubst must be defined.', TypeError('sequence item 3: expected str instance, NoneType found',))

Thanks,
Zizi

c...@cs.aau.dk

unread,
Feb 8, 2018, 3:22:25 AM2/8/18
to pygrametl-dev
Hello,

It seems you are using one of the classes supporting bulkloading, but did not specify a nullsubst when creating the instance. A nullsubst is a string value which your bulkloader accepts and replaces with NULL (see also the documentation).

Best regards,
Christian Thomsen
Reply all
Reply to author
Forward
0 new messages