Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load from field

Hi all,

I am using load form field in order to get some stuctured complex data from a field see above code:

TorqueData:

LOAD id,

     serial,

     firmware,

     data_bottom,

     date(testdata) as TestDate;

SQL select  *

from payouttensionlog.log

where testdata>='2013'

order by testdata desc

limit 50;

DataTest:

LOAD

     @1 as Turn,

     @2 as TorqueVal

FROM_FIELD

(TorqueData, data_bottom)

(txt, utf8, no labels, delimiter is ',', msq);

The problem is that i want to associate these load from field data in DataTest wih the id number in Torque Data....

Is there any easy way to achieve this???

Regards

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Load from field

Hi Kabilan,

I just tested your solution and works .

Thanks in advance for you help.

Your solution creates to many synthetic keys though...

I solved my problem in a more efficient way see below:

TorqueData3:

LOAD id,

     serial,

     firmware,

     data_bottom,

     SubField(data_bottom,';') as TorqueVal,

     date(testdata) as TestDate;

SQL select  id,

     serial,

     firmware,

     SUBSTRING(replace(data_bottom,'\n',';'), 1, CHAR_LENGTH(replace(data_bottom,'\n',';')) - 1) as data_bottom,

     testdata

from payouttensionlog.log

where testdata>='2013'

order by testdata desc

limit 50;

I replaced newline with semicolon and trimed the last char. This allowed me to use the native subfield function to achieve the result.

Kind regards,

7 Replies
agni_gold
Valued Contributor II

Re: Load from field

Hi,

You can use like this :

load  id,

           serial,

           firmware,

           data_bottom,

           TestDate 

Resident TorqueData;

if this helps please make correct answer .

Thanks

Best Regard

Agnivesh Kumar.

Not applicable

Re: Load from field

Hi Agnivesh,

I dont get your point???

What i need is to associate Turn,TorqueVal with the id in TorqueData of which they come from.

regards

Not applicable

Re: Load from field

TorqueData:

LOAD id,

     serial,

     firmware,

     data_bottom,

     date(testdata) as TestDate;

SQL select  *

from payouttensionlog.log

where testdata>='2013'

order by testdata desc

limit 50;

DataTest:

LOAD

     @1 as Turn,

     @2 as TorqueVal

FROM_FIELD

(TorqueData, data_bottom)

(txt, utf8, no labels, delimiter is ',', msq);

Tb1:

Load Turn&TorqueVal as databottom

     ,Turn

     ,TorqueVal

resistent DataTest;

left join

Load distinct data_bottom, id resistent TorqueData;

Regards,

Kabilan K.

Not applicable

Re: Load from field

Hi Kabilan,

I woudl expect the turn torqueval to look like above

0,32

1,128

2,140

3,150

4,155

5,161

6,165

7,167

8,170

9,170

10,172

11,172

12,174

13,174

14,176

15,178

64,182

For every id. But this is not the case in your solution.

Not applicable

Re: Load from field

Then use like below

Tb1:

Load Turn&','&TorqueVal as databottom

     ,Turn

     ,TorqueVal

resistent DataTest;

agni_gold
Valued Contributor II

Re: Load from field

Not applicable

Re: Load from field

Hi Kabilan,

I just tested your solution and works .

Thanks in advance for you help.

Your solution creates to many synthetic keys though...

I solved my problem in a more efficient way see below:

TorqueData3:

LOAD id,

     serial,

     firmware,

     data_bottom,

     SubField(data_bottom,';') as TorqueVal,

     date(testdata) as TestDate;

SQL select  id,

     serial,

     firmware,

     SUBSTRING(replace(data_bottom,'\n',';'), 1, CHAR_LENGTH(replace(data_bottom,'\n',';')) - 1) as data_bottom,

     testdata

from payouttensionlog.log

where testdata>='2013'

order by testdata desc

limit 50;

I replaced newline with semicolon and trimed the last char. This allowed me to use the native subfield function to achieve the result.

Kind regards,

Community Browser