Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rsvebeck
Valued Contributor

Is there a reversed Subfield function?

This is a question regarding a request for a function in the load script that works like the Subfield function, but the other way around.

Let me explain:

If I have source data like this:

TableA:

Col1  Col2 Col 3
A;B,C  100 A-10
A;G;E  200 A-20

I know how to use the Subfield function to get a table in Qlikview like this:

TableB:

Col1  Col2  Col3
A     100   A-10
B     100   A-10
C     100   A-10
A     200   A-20
G     200   A-20
E     200   A-20


But my question is, can we do it the other way around?

(Source table is TableB and output from the script is TableA)

Best Regards

Robert

1 Solution

Accepted Solutions

Is there a reversed Subfield function?

Hi,

     Then Col2 and col3 will be common?if so check with this

     Load

          Concat(Col1,';') as Col1,

          FirstValue(Col2) as Col2,

          FirstValue(Col3) as Col3

     From...Group by Col2,Col3;

Celambarasan

1 Reply

Is there a reversed Subfield function?

Hi,

     Then Col2 and col3 will be common?if so check with this

     Load

          Concat(Col1,';') as Col1,

          FirstValue(Col2) as Col2,

          FirstValue(Col3) as Col3

     From...Group by Col2,Col3;

Celambarasan

Community Browser