Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour
Y' a t il une personne qui peut me dire quel est l'erreur dans ces ligne de code
au fait je veux charger une table à partir d'une autre:
[FlowRaw]:
LOAD probe_id,
portal & host & end_date as host_key,
report_name,
report_is_top,
field_1,
field_2,
report_field_alias,
report_field_1,
report_field_2,
bytes_in,
bytes_out,
pkts_in,
pkts_out,
flows_in,
flows_out,
if(report_name = 'Remote Sites', report_field_alias, Null()) as range_name,
if(report_field_alias = 'TOTAL','Vrai','Faux') as is_total,
report_field_alias = 'OTHER' as is_other
FROM
[$(vExcelFiles)FLOW.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
[Flow]:
NoConcatenate
LOAD
*,
if(is_total='Vrai', if(bytes_in = 0 and bytes_out = 0,'Vrai','Faux'), 'Vide') as has_no_data, //'Non rensigné' correspond à null()
if(is_total='Vrai', if((bytes_in <> 0 or bytes_out <> 0) and (bytes_in = 0 or bytes_out = 0),'Vrai','Faux' ),'Vide') as is_asymetric, //'Non rensigné' correspond à null()
ApplyMap('RangeMapping', range_name, Null()) as range_country
RESIDENT FlowRaw;
DROP TABLE FlowRaw;
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
vous trouverez en pièce jointe une capture d'image de l'erreur qui m'affiche
merci
can u cross check this field "probe_id" is available on ur source FLOW.csv file?
The field probe_id does not exist in your source csv file.
can u cross check this field "probe_id" is available on ur source FLOW.csv file?
non il existe
seems some alignment problem,pls share ur data and qvw.
je ne comprends pas mon erreur
je suis desl