Is there a reversed Subfield function?

[RSvebeck]

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

[CELAMBARASAN · Accepted solution]

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