topic Re: Load multiple line into a variable in QlikView

Load multiple line into a variable

Wed, 15 Jul 2015 11:14:15 GMT

Hi Experts,

I need to load a multiple line from text and store it into a single variable, can someone please help me on the same?

Below is the scenario:

I have a text file in the system with the name sample.txt with below data.

Sample.txt

ABCDEF

GEFG

JSDFR

Now i need to load the file in the qlikview and store all 3 line in a single varaible

vData = 'ABCDEF

GEFG

JSDFR'

Please guide me on how to achieve this?

Re: Load multiple line into a variable

sunny_talwar — Wed, 15 Jul 2015 11:15:22 GMT

Try this:

LET vData = Concat(FieldName, Chr(13))

Table:

LOAD * Inline [

FieldName

ABCDEF

GEFG

JSDFR

];

Temp:

LOAD Concat(FieldName, Chr(13)) as Concat

Resident Table;

LET vData = Peek('Concat');

DROP Table Temp;

Re: Load multiple line into a variable

MayilVahanan — Wed, 15 Jul 2015 11:19:16 GMT

Try like this

= Concat(Distinct FieldName, Chr(10))

Re: Load multiple line into a variable

MK_QSL — Wed, 15 Jul 2015 11:20:08 GMT

Create a Variable

vVariable

definition

Concat(FieldName,CHR(10))

Use as below

=$(=vVariable)

Re: Load multiple line into a variable

sunny_talwar — Wed, 15 Jul 2015 11:22:25 GMT

Manish what is Chr(10)? Is it the same as Chr(13)???

Re: Load multiple line into a variable

MK_QSL — Wed, 15 Jul 2015 11:33:59 GMT

Chr(10) is for Line Break

Chr(13) is for Carriage Return

Re: Load multiple line into a variable

Wed, 15 Jul 2015 11:59:50 GMT

Thank you All for the quick response..It helped me a lot.

But now i have one more doubt on the same.

I amusing the below script:

But what happen here is in Temp table the Concat feild get sorted automatically i want them to be in the same format as in my data. Can you please help me?

Table:

LOAD @1 as FieldName,

AutoNumber(@1) as FieldNo

FROM

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

Temp:

LOAD Concat(FieldName, Chr(13)) as Concat

Resident Table order by FieldNo;

LET vData = Peek('Concat');

Re: Load multiple line into a variable

MayilVahanan — Wed, 15 Jul 2015 12:01:56 GMT

In that case, remove the order by statement.

Temp:

LOAD Concat(FieldName, Chr(13)) as Concat

Resident Table;

LET vData = Peek('Concat');

Re: Load multiple line into a variable

Wed, 15 Jul 2015 12:07:27 GMT

Hi,

It did not helped my friend, with or without order by

Re: Load multiple line into a variable

sunny_talwar — Wed, 15 Jul 2015 12:14:55 GMT

Try this:

Table:

LOAD *,

RowNo() as Sort

Inline [

FieldName

ABCDEF

JSDFR

GEFG

];

Temp:

LOAD Concat(FieldName, Chr(13), Sort) as Concat

Resident Table;

LET vData = Peek('Concat');

DROP Table Temp;

Re: Load multiple line into a variable

MK_QSL — Wed, 15 Jul 2015 12:16:52 GMT

Table:

LOAD *, RowNo() as ID

Inline

[

FieldName

ABCDEF

GEFG

JSDFR

];

Temp:

LOAD Concat(FieldName, Chr(13), ID) as Concat

Resident Table;

LET vData = Peek('Concat');

DROP Table Temp;

Re: Load multiple line into a variable

MayilVahanan — Wed, 15 Jul 2015 12:17:12 GMT

Try like this

Table:

LOAD @1 as FieldName,

AutoNumber(@1) as FieldNo,

RowNo() as RowNo

FROM

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

Temp:

LOAD Concat(I, Chr(13), RowNo) as Concat

Resident Table;

Re: Load multiple line into a variable

sunny_talwar — Wed, 15 Jul 2015 12:34:45 GMT

The indentation won't be the same, but you can get all of it here: PFA

Re: Load multiple line into a variable

qlikviewwizard — Wed, 15 Jul 2015 13:31:12 GMT

MRKachhiaIMP

What is Carriage Return?

Re: Load multiple line into a variable

MK_QSL — Wed, 15 Jul 2015 13:46:29 GMT

Carriage return - Wikipedia, the free encyclopedia