Split Field in Field Name and Values

[pamaxeed]

Hi guys,

is there a way to split the following Dimension Value:

Dim1:a;Dim2:x;

in the following output that i can have my table in qlikview like that:

Dim1	Dim2
a	x

Do I need to use Generic Load Prefix?

Thanks,

Patric

[sunny_talwar · Accepted solution]

May be this:

TableInput:

LOAD SubField(SubField(SubField(Field1, ';', 1), ':', 2), ',') as DIM1,

  SubField(SubField(SubField(Field1, ';', 2), ':', 2), ',') as DIM2;

LOAD * Inline [

Field1

Dim1:1,2;Dim2:1

] (delimiter is |);

Output

[pamaxeed]

Sunny thanks a lot.

It is what I was looking for!

At least it brings me a step furhter!

Patric

[miguelbraga]

The first dimension is given like this:

=SubField('Dim1:a;Dim2:x;', ':')

The second dimension is given like this

=SubField(SubField('Dim1:a;Dim2:x;', ':', 2), ';', 2)

"x" like this:

=SubField(SubField('Dim1:a;Dim2:x;', ';', 2), ':', 2)

"a" like this:

=SubField(SubField('Dim1:a;Dim2:x;', ';'), ':', 2)

[sunny_talwar]

Awesome

I am glad I was able to help you move forward.

Best,

Sunny

[miguelbraga]

I've found a similar question in community, take a look:

Split String Function In QlikView