Raws for missing value

[Anonymous]

Dear Community

I want to pop rows even which has no values without changing scrip. For below case I need C and D populated with empty rows

In my case

Prod:
LOAD * INLINE [
PC, Nm
A, ProdA
B, ProdB
C, ProdC
D, ProdD
E, ProdE
];

Sales:
LOAD * INLINE [
PC, Amt, SC
A, 1, S1
B, 2, S1
E, 5, S1
A, 11, S2
B, 12, S2
E, 15, S2
  ];

I am unable to attach QV file, I appreciate your help.

Thanks

[sunny_talwar]

Check these two on dimension tab also:

[Anonymous]

Hi Sunny

I also did but getting third empty unwanted column other than S1 & S2, like in your screen

Thanks

[Anonymous · Accepted solution]

It's resolved by adding same numbers of rows in through scripting with zero values.

Thanks