Need to copy the value of one column to other

[babud41]

QlikView 

Hi all,

I need to copy the value from one column and paste the same to other columns. I tried to do it doesn't work for me but the count of the same is working fine. Please suggest a solution for me.

I will attach the snap here.

Here I want to copy the values of Rx_optical_signal according to Report_hour to 8AM,12PM,4PM,8PM instead of count.

Kindly help.

[Or · Accepted solution]

It's a tad difficult to understand what exactly you mean and what your data structure is, but possibly the answer is to use, in your script,

Load YourField1, YourField2, Rx_optical_signal, Rx_optical_signal  as '8 AM', Rx_optical_signal  as '12 PM', Rx_optical_signal  as '4 PM', Rx_optical_signal  as '8 PM'

From YourTable;

You could then use e.g. Only ([8 AM]) or avg([8 AM]) to get the result that you seem to be describing.