Discussion Board for collaboration on QlikView Scripting.
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:
Col1 Col2 Col 3A;B,C 100 A-10A;G;E 200 A-20
I know how to use the Subfield function to get a table in Qlikview like this:
Col1 Col2 Col3A 100 A-10B 100 A-10C 100 A-10A 200 A-20G 200 A-20E 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)
Go to Solution.
Then Col2 and col3 will be common?if so check with this
Concat(Col1,';') as Col1,
FirstValue(Col2) as Col2,
FirstValue(Col3) as Col3
From...Group by Col2,Col3;