Discussion Board for collaboration on QlikView Scripting.
Dear Ladies and Gentlemen,
I would highly appreciate help on the topic below.
I've got Excel Spreadsheets, which have Orders with Products. Every Product could have different Configurations.
I would like to read in the Data with the Qlikview Script, that it looks like the following:
Is it's somehow the opposite of the subfield function. Is ther any chance to this?
Thank you very much for your help in advance,
Go to Solution.
Dear Celambarasan Adhimulam,
I tried your proposal and the script report says the following:
Concat([Variant],',') AS ConfigurationCommaSeparated
I've the feeling we are very close. Maybe we need to aggregate?
Try with Concat function Philips.
Concat(Configuration,',') AS ConfigurationCommaSeparated
Yes i missed to add Group by there
[Sales doc.], Material;
it is working perfectly! Thank you very much.
Just one question in addtion. How would you solve this, if every Configuration would have the following:
And you want get of all the Maschinexxx_
You mean like this?
Concat(SubField(Configuration,Replace(Product,' ','')&'_',2),',') AS ConfigCommaSeparated