Discussion Board for collaboration on QlikView Scripting.
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???
Go to Solution.
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.
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 .