Search Results

Hi ,
I have a typical situation. I have 4 files and with different headers (number of headers is varible ).
I need to make such a merged file which will have headers combined from all files (comman...

Hey Johnson. Here I am trying to do pivoting of the data. We have Market and Product for which we have variable number of facts and Period.
In input data key is made of markt,product and period and...

Thanks Cherry this helps but I have one more complication that ....there may be data like this -- (FOr few key values periods may differ and facts as well)

MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4...

Please help me to do Vertical an horizontal pivoing in unix in single run.
The input file is like this-


MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4
M1|P1|PR1|F11|F12|F13|F14...