DSXchange

Not just tables. From the error message: and has create table, create view, create index, and create trigger rights.

We seem to be missing some vital piece of information or this would have been solved some time ago seeing as how you've tried about every combination under the sun. What exactly is your source and how you are bringing it into the job? Are you certain that the format you posted as an example is accur...

And don't use pipes unless your values are pipe delimited in your source string. In other words, match what is existing in both what you tack on each end of the source string and what you wrap each word with. Your example showed spaces, hence my posted example. And then as Ray noted, you need to do ...

Let's start by getting you out of the Site forum and over here into the PX world...

The Pivot stage needs a fixed number of columns... as in the maximum you could possiblty get. Then as Ray notes you'd need to filter out the unused values (the NULLS) post-pivot. It works but you can end up creating a ton of records to filter out. Without transformer looping you may need to do this ...

Then it seems to me you are firmly in the hands of your support provider.

They are two separate options and one should not be affecting the other. What's in the Sequence job's log with regards to the Notification Activity stage, what information is it logging? Any issues with it finding the attachment? If this is a bug in your version and you truly are back in the 7.x wor...

Let's get you off to your own topic... and done. Split from this discussion by the way.

Nothing I posted restricts the source string to only a single word. What kind of trouble are you having? Can you post some examples?

Generated keys are unsigned 64-bit integers. I would think you'd just need to multiply each by -1 post generation to get what you want.

The trick to avoiding substring matches is to use delimiters, in this case a space. Add one on each end of the full string and each search term:

Search for " to " within " " : source_string : " "

Why are you using "yyyymmdd" in the function when your date is in "mmddyyyy" format?

They are deleted directly.

I just wanted to ensure you saw his entire response. The way I read it, the 'writing to a file' part was just to ensure the XML in the CLOB was well formed. Once that was confirmed, switch back to sourcing directly from the table but use the "content" option rather than the URL to read the...

Ernie said no such thing. Out of curiosity, has your premium membership expired?