Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Converting string ID's to numeric ID's

  • Jonas Boudewijns
  • Topic Author
  • Offline
  • User
  • User
More
5 years 3 months ago #3496 by Jonas Boudewijns
Converting string ID's to numeric ID's was created by Jonas Boudewijns
Hey Flowheater team,

I.m back with another little challenge that i need some advice or help with.

I'm converting a database of our client to one of our own databases, but they used some different parameters as the ones we can use.

Their account ID's are strings like C4F7C7CE-A4E0-DD11-9930-000C29CF5199, while the column we want to enter them into are numeric with a limit of 11. Normally i'd enter an auto ID here, but the catch is that some of their ID's are in the database multiple times for the same client with different addresses. These ID's need to stay the same. Therefore i don't think auto ID will do.

I guess a .net heater could do the trick, but i'm not a hero when it comes to .net, or maybe there's an even easier solution that i'm completely overlooking, so i wanted to know your take on this.

Thanks in advance for the help!

Please Log in to join the conversation.

  • Jonas Boudewijns
  • Topic Author
  • Offline
  • User
  • User
More
5 years 3 months ago #3497 by Jonas Boudewijns
Replied by Jonas Boudewijns on topic Converting string ID's to numeric ID's
I think i found the answer to my own question. I didn.t know that when you change the auto-id to group change with auto detect that it would allow you to connect with the read field. Bit of an oversight on my part.

This can be considered solved!

Please Log in to join the conversation.

Time to create page: 0.248 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.