Discussion Board for collaboration on QlikView Scripting.
I have data like
The result, I need
Hope someone help me
Go to Solution.
load rowno() as Id, subfield(row, ':', 2) as Field inline [
load Id, Field as No Resident tmp where Odd(Id);
join (final) load Id -1 as Id, Field as Name Resident tmp where not Odd(Id);
drop table tmp;
LOAD * Inline [
I need to loop through the data automaticaly
Not sure I understand what you mean. Can you elaborate your requirement?
if we have thousand of rows,
Loop through from first line to end
after 222 etc..
Why do you need to loop, why can't you do a simple load? Is data structured in a way that a regular load won't work? You need to provide some details in order to get what you are looking for.
I have external notepad file having data like
I have to load all data into table.
The table with columns like
if we give the notepad file path, The data should loaded automatically and generate the table as I expected.
Now its working .
Thanks to all
If you got what you wanted, please mark Massimo's answer as correct answer to close this thread.