July 14, 2015 at 1:57 pm
Hi,
i have a data like this
loan del recorddate
1000 30 12/31/2014
1000 60 1/31/2015
1000 90 2/28/2015
2000 curr 1/31/2015
2000 30 2/28/2015
2000 60 3/31/2015
3000 60 2/28/2015
3000 90 3/31/2015
3000 curr 4/30/2015
need to convert to
loan 12/31/2014 1/31/2014 2/28/2014 1/31/2015 2/28/2015 3/31/2015
1000 30 60 90 na na na
2000 na na na curr 30 60
While using pivot transformation i am getting error as
"cannot convert pivot key value "12/31/2014" to the datatype of pivot key column
just want to know any ideas and suggestions?
July 14, 2015 at 2:38 pm
I used your data and just copied it to a text file. Then on the Data tab, I chose From Text, and specified during that process that the recorddate column was a date. After that it was easy.
Rows: loan
Columns: recorddate
Value:Sum of del
July 14, 2015 at 8:11 pm
OK got it..but the issue is if i run this one again next month it will not run ..because new loans will be added with end date 06/30/2015..As there will be no pivot column with 06/30/2015 ..it will generate error...is there any way we can generate pivot columns as soon as it will see new value?
July 14, 2015 at 8:19 pm
July 14, 2015 at 8:27 pm
I am working in SSIS ..when it see new value i am getting below error
"[Pivot [29]] Error: The pivot key value "1/31/2015" is not valid.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply