MySQL Forums
Forum List  »  Partitioning

Need to partition a string with unique leading numbers HELP
Posted by: Phillip Marquis
Date: May 01, 2018 01:38PM


I am hoping this question/issue has not already been asked/addressed, if so, please point me to the thread. For the record, I can not write SQL.

My issue is:

I have a file coming into Responsys SFTP daily that a connect job grabs and puts into a supplemental table.

The file has two columns (EMAIL and COUPON_CODE). The issue with this file is that there are two coupon types in the COUPON_CODE column. One type, the code string begins with 999 and the other begins with 998.

I need the two types to be separated into their own columns in the supplemental table in Responsys.

Is there a SQL that can identify the code type (using the unique leading numbers)and create a new column for each coupon type in a supplemental table?

Please let me know if you have done this before and can provide any guidance!

Thank you!

Phill M.

Options: ReplyQuote

Written By
Need to partition a string with unique leading numbers HELP
May 01, 2018 01:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.