Discussion Board for collaboration regarding Qlik DataMarket.
I have a requirement to properly format the file while loading.
Original data in file
Go to Solution.
May be like this:
LOAD SubField(Country, '(', 1) as Country,
LOAD SubField(Country, ';') as Country,
(html, codepage is 1252, embedded labels, table is @1);
May be this:
LOAD RowNo() as RowNo,
SubField(Region, ';') as Region,
Thanks for the reply.
On seeing the above result.
Saudi -----> EUR
but saudi should fall undar ME
along with this
On country field values are not consistent some time it is coming as India, India(ASP), India (ASP), India(India)
I want to make it consistant and everywhere it should display in appropriate name.
It code seems to be follow the order. Not sure if you want the code to be more smart. Can you may be use mapping load if you already know that UK will always be EUR? and IND will always be ASP?
Yes UK will always be EUR and IND will always be ASP.
Will you be able to provide be some example for mapping load as I am new to qlikview.
Many thanks in Advance!
Don't join - use Applymap instead
Using ApplyMap() Function with Mapping Load in QlikView - QlikView Blog, QlikView Videos and Tips at...
Can we remove text within brackets
India(ASP) should be displayed as India only, else I have to maintain multiple values in mapping table.