topic Re: How Can we load Pipe delimeter separated data in Qlikview in QlikView

How Can we load Pipe delimeter separated data in Qlikview

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

How Can we load such pipe delimeter format in Qlikview?

Please have a look on format attached of sample data?

Re: How Can we load Pipe delimeter separated data in Qlikview

sunny_talwar — Thu, 06 Oct 2016 12:09:06 GMT

Convert your file into csv and then try this:

Table:

LOAD @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,

@32,

@33,

@34,

@35,

@36,

@37,

@38,

@39,

@40,

@41,

@42,

@43,

@44,

@45,

@46,

@47,

@48,

@49,

@50,

@51,

@52,

@53,

@54,

@55,

@56,

@57

FROM

Testdata.csv

(txt, codepage is 1252, no labels, delimiter is '|', msq);

Re: How Can we load Pipe delimeter separated data in Qlikview

sspawar88 — Thu, 06 Oct 2016 12:21:58 GMT

Hello Sunny,

Convert means what you are doing exactly to given file?

Re: How Can we load Pipe delimeter separated data in Qlikview

Anonymous — Thu, 06 Oct 2016 12:26:25 GMT

Hi Satish,

1.Copy that data into Note Pad

2. Load that file into Qlikview

3. Select Delimiter>Custom>Select ' | ' > Click Ok > Finish

Hope it helps!!

Re: How Can we load Pipe delimeter separated data in Qlikview

sunny_talwar — Thu, 06 Oct 2016 12:39:23 GMT

Convert means to open your Excel file and save it as a CSV file.

Re: How Can we load Pipe delimeter separated data in Qlikview

awhitfield — Thu, 06 Oct 2016 13:07:29 GMT

Hi satish,

copy the data into a text file, then in script editor use 'Table Files' navigate to your text file, andconfirgure the setting as soon:

and you'll end up with the script below:

Directory;
LOAD @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,
@32,
@33,
@34,
@35,
@36,
@37,
@38,
@39,
@40,
@41,
@42,
@43,
@44,
@45,
@46,
@47,
@48,
@49,
@50,
@51,
@52,
@53,
@54,
@55,
@56,
@57
FROM
pipe.txt
(txt, codepage is 1252, no labels, delimiter is '|', msq);

HTH Andy

Re: How Can we load Pipe delimeter separated data in Qlikview

vishsaggi — Thu, 06 Oct 2016 13:49:05 GMT

Not a Qlikview solution 😉 , but you can easily convert your excel file data with Pipe delimiter using "Text to Columns" option in DATA tab of your excel sheet and follow accordingly. 🙂