topic Re: hI ALL small trasnformations? in QlikView

hI ALL small trasnformations?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 22 Mar 2016 10:29:39 GMT

See attached example for one solution.

Anonymous — Tue, 22 Mar 2016 10:32:39 GMT

Hi Gysbert,

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

ramasaisaksoft — Tue, 22 Mar 2016 10:56:59 GMT

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 — Tue, 22 Mar 2016 11:03:35 GMT

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 — Tue, 22 Mar 2016 11:07:21 GMT

No.

Anonymous — Tue, 22 Mar 2016 11:12:06 GMT

Thanks GYSBERT