Strategy for partitioning according to a substring

[former_member207606]

Hello

I am looking for a reasonable strategy for table partitioning of my header table.

The first row looks like this:

DWID;DWSource;DWAuditID;InteractionID

4D494D49434C41424556454E545F3138383030333238;NULL;142;LABEVENT_18800328

It would be very helpful to be able to partition according to "InteractionID" where the values are composed in the pattern: TEXT_NUMBER

I'd love to realize a RANGE Partitioning according to TEXT where each TEXT substring element would define one Range.

Is this somehow possible?

[lbreddemann]

Hi Bernd

happy to have this discussion with you. As I am familiar with the use case just send me an email and we can look into this.

Cheers,

Lars