Discussion Board for collaboration on QlikView Scripting.
I am having tables,
after joining I want output like,
how should I achieve it?
Go to Solution.
Can you close the thread by selection correct answer?
Try this in the load script...
LOAD * Inline [id1,id2,value
LOAD * Inline [id1,pg1
LOAD * Inline [id2,pg2
Sum(value) as value1
Resident t1 Group By id1, id2, pg1, pg2;
Drop Table t1;
Your data looks OK. Create a straight table with id1 and id2 as dimensions and pg1 and value as expressions. Turn off the totals on the expressions as they will have no meaning.
Edit: looking back, use sum(value) and leave totals on for that expression.
as Jonathan says you don't need to join anything
load * inline [
but the RESULT is slightly different from your
Mapping Load * Inline
Load * Inline
id1, id2, value
A, 1, 100
B, 2, 120
C, 3, 140
Load id1, id2, value, IF(pg1='',ApplyMap('TEMP',id2),pg1) as pg1 Resident T1;
Drop Table T1;
sorry,but i am having pg2 instead of pg1 in table t3
Check my solution. I have tested and it's working as per your requirement.
Thanks,It's working fine
Hi Manish your script is not working when i am doing same thing with excel/qvd files?