Hi, I am having problems creating a new Column where I have to use a condition. The context is: I have a table with the columns: -ID -credit card: it can be visa or master. -amount: the amount in $ The objetive is not to be repetitive with the id if the client has visa and master. So I need 2 new columns where: if the credit card is from visa the new column "Amount_Visa" has the consolidated amount. And if its from master, the new column "Amount_Master" has its amount. Now I have this: ID Credit card Amount 1 visa 230.60 1 master 456.30 And I need this: ID Credit Card Amount_Visa Amount_Master 1 Visa/Master 230.60 456.30 Thank you!
... View more