Load from field

[#1]

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

[agni_gold]

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.

[#3]

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

[#4]

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.

[#5]

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.

[#6]

Then use like below

Tb1:

Load Turn&','&TorqueVal as databottom

     ,Turn

     ,TorqueVal

resistent DataTest;

[agni_gold]

K Kabilan  is right .

[#8 · Accepted solution]

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,