Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
there is a way to create flag in the script but do them external to qlivkiew? using a notepad? or excel?
i want to create a normal flag in the script like
"if (lenguague = 1,'ESPAÑOL','ENGLISH') as Lenguague; but not do this in the load script, do it in a txt external or excel? and then include?
i try to do something like
Lenguague:
LOAD
CodLenguague,
Type,
$(Include=C:\Users\Desktop\NEWVER\FLAG.txt) // THIS IS THE NOTEPAD WITH THE FLAGS
FROM
EXAMPLE.QVD(QVD)
what would suggest or recommend? thank you a lot
i want to mantein and manage all the flags external qlikview
Fernando
Thank you both of you!
two different solution works fine!
I put an example , thank you again
Fernando
---------------------------------------------------------------------------------------------------------------------
EJECUTIVOS:
LOAD
CodEmp,
NombreEmpl,
Rubro,
$(Include=C:\Users\fkeuroglian\Desktop\NEWVER\Banderas.txt)
FROM
PruebaBanderas.qvd
(qvd);
---------------------------------------------------------------------------------------------------------------------
Hi
It really depends on who will manage it?
1. You:
If there are not a lot of matches and have only one field for replacing you can leave it in qvs and use ApplyMap and Mapping load. Otherwise you can have separate xls file and join these data later.
2. Your users:
I think it would be better to have everything in xls, and use joins or ApplyMap
In your example you can use Mapping Load and ApplyMap. Mapping load you can move to the external qvs file.
You can do that. I am not sure if you are asking for suggestion or how-to-do. If it is how-to-do, then let me tell you that you are almost there. Only thing may be you are doing wrong is a comma or semi-colon. If it is your last statement in the load then you don't need a comma either in the external file or in the load statement itself. And no semi-colon for eithe of the cases.
Thank you both of you!
two different solution works fine!
I put an example , thank you again
Fernando
---------------------------------------------------------------------------------------------------------------------
EJECUTIVOS:
LOAD
CodEmp,
NombreEmpl,
Rubro,
$(Include=C:\Users\fkeuroglian\Desktop\NEWVER\Banderas.txt)
FROM
PruebaBanderas.qvd
(qvd);
---------------------------------------------------------------------------------------------------------------------