Discussion Board for collaboration on QlikView Scripting.
Would you possibly advise how to convert values in a column into the form ('(value1)','(value2)',......)?
Let's say there is unique values in a single column table;
I would like to create something like
I would highly appreciarte for your input.
If you always know number of rows then this is simple:
Let vCond = Chr(39)&peek('Data',Unique,0)&Chr(39)&Chr(39)&peek('Data',Unique,1)...
If you don't know number of rows, then you have to loop that:
Let vCond = vCond&Chr(39)&peek('Data',Unique,$(i))
Hi, I tried loop but I could not make it.
The maximum number of rows comes NoOfRows(), so I set
For i=0 to $(vMax)
Let vCond = vCond&Chr(39)&peek('Data',$(i),'Unique');
Somehow it failed to result.
Thank you, CONCAT idea was excellent. I did not know.
Below finally worked.
This is for 'a','b','c','d','e'
I will add () in later part of script. Thank you.
Hi sorry to interrupt again: above method did not work within the script.
Somehow I cannot pass the variable to the script execusion. I am testing more to make feedback official.
Would you happened to know if I should do this conversion, just to use this variable range in MATCH() function?
I am in need to make a loading script where:
WHERE MATCH(UNIQUE, (data)) >0
Maybe I do not need such thing but simply UNIQUE = (data column name)?