Discussion Board for collaboration on QlikView Scripting.
I'm looking to perform the following task in QV:
How can i achieve this ? I imagine there is a previous command involved. Just unsure as to how to frame the logic.
All suggestions are welcome. Thanks
Go to Solution.
if(Peek('New Column')<>Null(),Peek('New Column'),Null())& Value as [New Column];
LOAD * INLINE [
View solution in original post
May be like this
Alt(Peek('New Column'), '') & ',' & Value as [New Column]
My intentions were right, but I should have thought through or tested my code .
Peek('New Column') & Value & ',' as [New Column];
Left([New Column], Len([New Column]) - 1) as [New Column]
DROP Table Table;