You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Split Concatenation and SQL

Accepted answer
11
Views
1
Comments
edited Oct 27, 2021 12:49PM in Planning 1 comment

Summary:

Split Concatenation and SQL

Content (required):

Am processing rows using concatenated values where each segment is separated by an underscore character (_) Ex: A23_B11011_C13432_DEF1232 and it works fine if I use <1>, <2>, <3>, <4> for each of the 4 dim.

Source values can be A23_B11011_C13432_DEF1232, A23_B11012-C13432_NA_F1232 etc.. When it is A23_B11012-C13432_NA_F1232 where NA_F1232 is member name(default) of the 4th dimension(has a underscore in member name) and the <4> brings up only NA and not NA_F1232. Wherever I find members without underscore it needs to be loaded AS IS(DEF1232) and default to NA_F1232 otherwise

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!