Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have one dummy data sample file which i need to automate into QV,
first raw is name of excel as output, second raws are headers(column) each header is seperated by " | " sign.
e.g
TAGFile_Extraction = outpit file name
Partner (Full Label)|Agreement (Full Label)|Scheme (Full Label)| Headers for excel
[223] Volkswagen India Private Limited|[2500022] Volkswagen India Assistance|[250002201] Volkswagen Assistance|
i want to pull it into qv first and automate as well.
can any one suggest me this how i can do this.. the format will be standard...
Hi jagan ,
thanks for your help,, pls help me to sort out as well
Please find the attached file i am working,,
also i have tried by replacing file path u have shared but in output file there are ' " ' still available..find output file as data in it..
pls suggest..
Now load this Data.txt file using script below
LOAD *
FROM
[Data.txt]
(txt, utf8, embedded labels, delimiter is '|');
Regards,
Jagan.
Hi jagan,
thanks but,
have u seen the output data file which i have attached? it is still containing ' " ' in it.
if i m loading it than again same issue the data in partner Fill label Column not seperating..
pls find the app again with script..
LOAD replace([Partner (Full Label)],'"','') as [Partner (Full Label)],
[Agreement (Full Label)],
[Scheme (Full Label)],
[Guarantee (Full Label)],
[Service (Full Label)],
[Cause (Full Label)],
[Case Created By (Operator Full Name)],
[Service Assigned By (Operator Full Name)],
[Assignment (Creation Date)],
[Assignment (Creation Time)],
[Case (Creation Date)],
[Case (Creation Time)],
[Assignment (Reference)],
[Assignment Status (Full Label)],
[Expected intervention (Date)],
[Expected intervention (Time)],
[Real intervention beginning (Date)],
[Real intervention beginning (Time )],
[Real intervention end (Date)],
[Real intervention end (Time )],
[Case Sub Type (Full Label)],
[Case Type (Label)],
[Incident (Date)],
[Incident Location (Address)],
[Afterwards case?],
[Case (reference)],
[Case (Closing Date)],
[Case (Closing Time)],
[Case (Completed Date)],
[Case (Completed Time)],
[Case (Comment)],
[Case Status (Label)],
[Partner Case (Reference)],
[Vehicle Brand (Label)],
[Vehicle (Model)],
[Vehicle (Registration)],
[Vehicle (First Registration Date)],
[Vehicle (Vehicle Color)],
[Vehicle (Vehicle Mileage)],
[Completion Duration],
[Out of coverage?],
[Arrival place description (garage name)],
[Arrival Address],
[Arrival Town (Name)],
[Arrival Department (Name)],
[Policy (Reference)],
[Policy (Start Date)],
[Policy (End Date)],
[Incident Location (Town)],
[Incident Location Department (Name)],
[Service Cost Estimate Payment Amount With Tax (Foreign)],
[Assisted (Full Name)],
[Caller Full (Name)],
[Caller (Phone Number)],
[Company Caller (Name)],
[Provider (Adress)],
[Provider (Code)],
[Provider (Name)],
[Subscriber (Full Name)],
[Purchase (Date)],
[Mission Actual Distance Value],
[Service Cost Estimate Payment Amount Without Tax (Foreign)],
[Provider (Comment)],
String1,
String2,
String3,
String4,
String5,
String6,
String7,
String8,
String9,
String10,
String11,
String12,
String13,
String14,
String15,
Numeric1,
Numeric2,
Numeric3,
Numeric4,
Numeric5,
Numeric6,
Numeric7,
Numeric8,
Numeric9,
Numeric10,
Numeric11,
Numeric12,
Numeric13,
Numeric14,
Numeric15,
Date1,
Date2,
Date3,
Date4,
Date5,
Date6,
Date7,
Date8,
Date9,
Date10,
Date11,
Date12,
Date13,
Date14,
Date15,
Bool1,
Bool2,
Bool3,
Bool4,
Bool5,
Bool6,
Bool7,
Bool8,
Bool9,
Bool10,
Bool11,
Bool12,
Bool13,
Bool14,
Bool15,
String16,
String17,
String18,
String19,
String20,
String21,
String22,
String23,
String24,
String25,
String26,
String27,
String28,
String29,
String30
(txt, utf8, embedded labels, delimiter is '|', no quotes);
try this.
hey jagan pls suggest.. thanks
pls revert
Hi,
I am not sure why it is not working for you.
hi jagan ,
can u share the file gain with the output which is working at your end pls..
