How Can we load Pipe delimeter separated data in Qlikview

[sspawar88]

Hi Community,

How Can we load such pipe delimeter format in Qlikview?

Please have a look on format attached of sample data?

[sunny_talwar]

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);

[sspawar88]

Hello Sunny,

Convert means what you are doing exactly to given file?

[Anonymous]

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!!

[sunny_talwar]

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

[awhitfield · Accepted solution]

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

[vishsaggi]

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. 🙂