Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RSvebeck
Specialist
Specialist

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

Svebeck Consulting AB
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

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

View solution in original post

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

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