Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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