Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Erreur code qlik

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

Capture1.PNG

merci

1 Solution

Accepted Solutions
buzzy996
Master II
Master II

can u cross check this field "probe_id" is available on ur source FLOW.csv file?

View solution in original post

7 Replies
Gysbert_Wassenaar

The field probe_id does not exist in your source csv file.


talk is cheap, supply exceeds demand
buzzy996
Master II
Master II

can u cross check this field "probe_id" is available on ur source FLOW.csv file?

Not applicable
Author

non il existe Capture2.PNG

Not applicable
Author

Capture2.PNG

buzzy996
Master II
Master II

seems some alignment problem,pls share ur data and qvw.

Not applicable
Author

Capture3.PNG

Not applicable
Author

je ne comprends pas mon erreur

je suis desl