Discussion Board for collaboration on QlikView Scripting.
Hi fellow Qlikview devlopers,
I have intersting data manipulation challenge. I have simple column where data is broken in the following manner (table 1)
I have to take table 1 and insert a new row above everytime i see the value A. The position of this new inserted row is very important (table 2).
Thanks for your time.
Go to Solution.
Something like this:
LOAD *, RowNo() as rowid INLINE [
Load * inline [
load if(Dummy=2,null(),Column1) as Column1, Dummy
Resident T1 Order by rowid, Dummy desc;
drop field Dummy;
drop table T1;
Thanks a lot.