MySQL Forums
Forum List  »  Newbie

Need SQL to create new columns from one column based on unique leading numbers
Posted by: Phillip Marquis
Date: May 01, 2018 01:27PM

Hello!

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


Subject
Written By
Posted
Need SQL to create new columns from one column based on unique leading numbers
May 01, 2018 01:27PM


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.