My qvw file contains sensitive customer data, so I will not be able to post it.
There are 3 fields involved. Type,PAREA,DAREA which I want to combine into a new field ROUTE.
In my inline table, I have a ROUTE field containing some possible combinations of the 3 fields eg B_D1_D2.
In my script, if TYPE&'_'&PAREA&'_'&DAREA is present in the ROUTE field in my inline table, then I want to load that value as ROUTE. If not I want to load another value.
So, for instance, if TYPE&'_'&PAREA&'_'&DAREA = B_D1_D2, then load B_D1_D2 as ROUTE, if not, load B_Other as ROUTE
Hope this helps
Thank you for your speedy response.
I have no SQL expertise, so could you explain your answer?
I need all records to load (I should have mentioned, there are a number of other fields involved).
I see you suggest creating a new-route field. I can understand that.
But does your solution mean I split the load into 2 parts.The first load will load only those records where the ROUTE exists. Then a second load where the ROUTE does not exist?
'TYPE'&'_'&PAREA&'_'&DAREA as new_route etc
In the first part you load only the rows that have a ROUTE, it doesn't matter if you have more fields it still works, in the second part you load the rest of the rows, this will generate two tables, with the same fields including new_route; if two tables have the same name and number of fields qlikview will concatenate them automaticaly, so the result is one table with the rows of the first table + the rows of the second table, you can use the function concatenate(table_name) to do the same;you can find more information and examples about the exists() and concatenate() functions in the QlikView help
Hope this explains better
I have a doubt. I am having a filed Quality Description. I need to create a new field for all the records having qualtiy desc. the value of this field will be 'Yes' if the quality Desc ends with 'FSR' and No if its not 'FSR. later I will calculate the percentage of yes over no to show in input box.