Discussion Board for collaboration on QlikView Scripting.
I try to do something, but i don't know if it's possible.
I need your help.
My exemple is very simplistic, but in reality, my datas are much complexe and i must load them in the exemple order.
First table : TABLE1
Second table join to the first table with concatenate (TABLE1)
The third table to complete partial column Country
Expected résult with a left join
In sql, i should do something with where clause : where table1.country is null or in join statement table1.country=table3.country and table1.country is null.
How to do something similar in Qlikview ?
I have an issue by adding a new field in left join, drop the older and rename new field.
Left join (Table1)
Country as Country_temp
Drop field Country from Table1;
Rename Country_temp to Country;
If you have another solution !?!
May be using ApplyMap with Mapping load
LOAD * INLINE [
USA, New York
USA, Los Angeles
New York, English
LOAD If(Len(Trim(Country)) = 0, ApplyMap('TABLE3', City), Country) as Country,
DROP Table TABLE1;
It's a possible solution for my problem but, as i have a lot of data, reload all data several times will slow down too much my global load.
I am not sure what extra load are you seeing above? I mean I have a final load, but you mentioned several times? I am not sure what you mean when you say reload all data several times?
sorry, i was not clear.
This manipulation comes back several times in my script for different value.
I must proceed with intermediate steps to complete my data, so reload several times the totality of the data it's not possible.
Unless you show your script of what you have, I am having a hard time picturing what you have and why you end up with several manipulative resident loads. I really want to help, but I won't be without more information