×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sorting by date — IDD 6.03

Sorting by date — IDD 6.03

Sorting by date — IDD 6.03

(OP)
I have a field called 'Arrival Date' in Analysis Workbench taken in dd/mm/yyyy format. It's not a proper date object, just a string, so when I try to sort by Arrival Date date you can imagine the screwy results I get.

If I could reformat to yyyy-mm-dd that would be much better. Is there any way I can do that without manually typing in all the new dates?

RE: Sorting by date — IDD 6.03

(OP)
Currently thinking of installing Cascade and looping through the DB to make the required changes — then getting rid of Cascade again cause I don't really need it.

I'll post it up if/when it works.

RE: Sorting by date — IDD 6.03

In PDI v7.x (and possibly in IDD v6 as well - I don't recall), you can work around the issue if you do a little bit of work.  

First load all of your scan files into AW - hardware-only is just fine, so it should be super-fast, particularly if you load .FSF files.  Then do an export of the hardware data to CSV format, exporting the asset tag and the "arrival date" columns.

Now close AW and load the CSV file into a suitable editor - I guess Excel might do it, although I would use a good text editor.  Then change the contents of the date field to be yyyy-mm-dd using the editor.

Now restart AW, and define a new Analysis Asset Field in the Load Options, using the CSV option.  Point it to your edited CSV file, and let AW know which field is the asset tag field.

Wen you now load your data, you will have a new column containing your sortable date field.  The CSV feature can of course be used for other things as well, but this should get you going.

I hope this helps you,
Allan

RE: Sorting by date — IDD 6.03

(OP)
My development request has finally come through in 7.3.1 so I'll be trying it after the upgrade.

(Just in case you thought I was ungrateful for not posting back. )

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close