1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
LET i=10;
...
for i=10 to 13
Directory;
Concatenate LOAD
Timestamp(Floor([YYYY-MM-DD])+Frac([HH:MM:SS]), 'DD/MM/YYYY hh:mm:ss') as [DateNiv],
[YYYY-MM-DD] as [Date2Niv],
if(hour([HH:MM:SS])<12,'AM','PM') as [Periode],
year([YYYY-MM-DD]) as [Annee],
month([YYYY-MM-DD]) as [Mois],
day([YYYY-MM-DD]) as [Jour],
if i=10 then
[Htr01] as [Niveau];
'T1' as [Capteur];
elseif i=11 then
[Htr02] as [Niveau];
'T2' as [Capteur];
elseif i=12 then
[Htr03] as [Niveau];
'T3' as [Capteur];
else i=13
[Htr04] as [Niveau];
'T4' as [Capteur];
end if
FROM
[Qlikview Data Sources\Niv\aa.txt]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);
next i |
Partager