Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am facing a problem with delimiters in Qlikview. I have data with '|' as delimiters, however based on sample data as below qlikview does not recognize '|' as delimiters due to apostrophe ( ' ). When i loaded the data into Qlikview, the data is combined it into one field instead of separate field.
Any advice or solution could fix the problem? Thanks!!?
Hi Meng Hui Lee,
Is that actually a delimited file? It also looks like fixed size. Anyway, make sure you are specifying "no quotes" in the load statement file options.
As a last resort, do MSQ format truncates data while loading from delimited text file
Miguel
Hi,
I recently i also faced delimeter issue, got resolved.
Can u share ur table script and output ?
while loading from SAP report Delimeter issues will come by following reasons:
Do the test run with above change and probably with a new test report created in SAP not having any sorting, to isolate any human error. I believe that this should work however considering remote possibilities of other factors, kindly follow the steps below in case the above fails:
-Nagarjun
Hi,
Thank you for your replied.
Let me explain more details on it. I do need load the data into Qlikview, but i found there is one row of the record not loaded accordingly due to the apostrophe ('). My delimiter is vertical line (|) , but the data have the apostrophe after the delimiter. Ex: |'AINUL AFIQAH BINTI |'AINUL AFIQAH BINTI |
So Qlikview doesn't recognized the vertical line as delimiter, in fact this 2 ( 'AINUL AFIQAH BINTI ) should be insert into different field instead of gather into one field. My expected output have to consist the apostrophe also, so i hope to find a solution to load this data into database with separate field.
.txt data file:
Output:
Expected output:
I had this same problem when using SAP Concur files with Qlik Sense November 2018. A few records in the '|' delimited text files had apostrophes next to the delimiter and caused it to not be recognized for some reason. Switched from msq to no quotes and it worked! Very odd though.