Is there a reversed Subfield function?

RSvebeck — Fri, 16 Mar 2012 07:49:14 GMT

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 — Fri, 16 Mar 2012 09:18:17 GMT

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

topic Is there a reversed Subfield function? in QlikView