This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am using load form field in order to get some stuctured complex data from a field see above code:
date(testdata) as TestDate;
SQL select *
order by testdata desc
@1 as Turn,
@2 as TorqueVal
(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???
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:
SubField(data_bottom,';') as TorqueVal,
SQL select id,
SUBSTRING(replace(data_bottom,'\n',';'), 1, CHAR_LENGTH(replace(data_bottom,'\n',';')) - 1) as data_bottom,
I replaced newline with semicolon and trimed the last char. This allowed me to use the native subfield function to achieve the result.
View solution in original post
You can use like this :
if this helps please make correct answer .
I dont get your point???
What i need is to associate Turn,TorqueVal with the id in TorqueData of which they come from.
Load Turn&TorqueVal as databottom
Load distinct data_bottom, id resistent TorqueData;
I woudl expect the turn torqueval to look like above
For every id. But this is not the case in your solution.
Then use like below
Load Turn&','&TorqueVal as databottom
K Kabilan is right .