hI ALL small trasnformations?

[Anonymous]

Hi all,

I have attached one excel file . in that excel I have sheets like Test,output

I want load the data from that Test sheet  and want display final output like in the OUTPUT SHEET?

Can any one give me correct code for this how to write for this ?

[Gysbert_Wassenaar · Accepted solution]

See attached example for one solution.

[Anonymous]

Hi Gysbert,

it looks good but my intention to do this in single load statement ?is it possible ?

[ramasaisaksoft]

Hi Common,

What is the problem even you write n number of queries there is no Syn keys? any way

If you want in a single query then you need to change Excel itself(as per your convenient)then fetch data into QV.

[Anonymous]

I am not telling like there is a problem

Just checking like possibility ways.

let say Xl sheet has given by client  then how can I change the format of the xl ?

[Gysbert_Wassenaar]

No.

[Anonymous]

Thanks GYSBERT