Comments
-
David, This gives me some other approaches and thought. I really appreciate it. Thank you,
-
I understand what you are stating. Just hoping for some easy way to do this without someone remembering to write them down. I would say we could do it for a week or two and then just do a check every other month for about a week. Thank you for your help.
-
I studied this some more, and I came up with a solution. It is a little funky, but it worked. Sorry if I don't describe this like a master would. 1st - changed the dollar amount to a string. 2nd - grouped the description and the strings using the "GROUP BY" function under "Aggregate". This cut me down to 1 row for each…
-
Mark - I do appreciate the response. It just seems to me something is missing in the ETL process. I use another ETL tool for ad hoc reporting, and it dynamically adds the columns. I'm afraid the solution to this is to have many more rows than are needed. Maybe no other choice. Thank you,
-
I looks like I now need to change the database field from a string to a number.
-
Marcel - What you provided seems to get me off that trap. Now, I'm running into the error of : ORA-0122:invalid nubmer I will do some research on this. Do you happen to know what this means? Thank you,
