Solved!
Go to SolutionExternal DataSource and Cast
Hello,
I'm trying to get some clone task information.
In order to do this, I gathering nsradmin data. Get it in a CSV format. Transform date and time info into timestamp format. And give this information to DPA.
But I set cast for each column (sting, timestamp, int, duration).
But on the report preview, the timestamp is displayed "as a big number". And in the table format -> Series -> Column format the cast is set to text.
What"s the problem ?
Thanks
1207
0
Posted October 12th, 2015 07:00
Hello,
Same result.
Here are some screenshot :
1207
0
Posted October 12th, 2015 07:00
If the data is being read in as a number i.e. 17695647376398, this is because it is being read in as unix ctime.
The cast of the column should be date, and if you’re reading it in from csv the cast should be date
Regards
John Finn
UPCOMING ANNUAL LEAVE: Oct 16th
1207
0
Posted October 12th, 2015 07:00
1207
0
Posted October 12th, 2015 23:00
Your "Edit Parameters" look fine.
Your "Format Columns" don't. The Format Columns should be "Date" for any item that is a date, unless the date is read in as a string.
1207
0
Posted October 13th, 2015 00:00
Hello,
You're right, i should be date, but I can't change it ! Or I don"t know how to change this settings !
Thanks .
Mickael
1207
1
Posted October 13th, 2015 08:00
Hello,
Thanks so much for your help.
I've delete the connection and recreate it, and tada !!! It's works. Cqast are good.
thanks you very much.
Mickael
finnj7
6 Posts
1207
0
Posted October 13th, 2015 03:00
Click on the Format Columns. There should be a drop down button beside each of the fields where you can change the cast from Text to Date.
Failing that, remove the connection from the ReadCsv data source to the nearest operator or the end of the report. Once you add it again the date field should propogate throughout the report. I can't really see exactly what it is you're trying to do, or what your report looks like, so it's not easy to say exactly where it is you're going wrong.