topic transformation in QlikView

transformation

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

Hi All

I stuck at some point couldn't find the possible solution, I got two table which I attached below when I'm loading the data its not giving me the correct format !

Re: transformation

varshavig12 — Thu, 08 Sep 2016 09:05:07 GMT

Can you please let us know, what are you getting and what you want ?

Re: transformation

varshavig12 — Thu, 08 Sep 2016 09:06:30 GMT

May be a sample of the output.

Current output and the desired one.

Re: transformation

susovan — Thu, 08 Sep 2016 09:10:20 GMT

You can use this two tables through different excel sheet.

Re: transformation

Anil_Babu_Samineni — Thu, 08 Sep 2016 09:25:29 GMT

See like this for 1st one?

Re: transformation

nareshthavidishetty — Thu, 08 Sep 2016 09:28:03 GMT

I'm looking for data loading in correct format as u can c the date rows 8-1,8-2,8-3 ..... so on upto 8-31 it should be in proper date format 1-aug,2,-aug....

Re: transformation

teiswamsler — Thu, 08 Sep 2016 09:38:01 GMT

hi nareshthavidishetty nareshthavidishetty

Its a complex excel.

You have to load the excel i stages.

Using the transform wizard and crosstable funktion.

/Teis

Re: transformation

varshavig12 — Thu, 08 Sep 2016 09:42:43 GMT

Try this.

Re: transformation

nareshthavidishetty — Thu, 08 Sep 2016 10:10:43 GMT

I got for the first table what abt second table to load and get date format as it is showing only number whn I load in qlik

LOAD [Employee Name],

[Team Name],

[1],

[2],

[3],

[4],

[5],

[6],

where all this 1,2,3,4 should be 1-jun,2-jun so on like that

Re: transformation

varshavig12 — Thu, 08 Sep 2016 10:40:36 GMT

for the second table where is the month ?

Re: transformation

nareshthavidishetty — Fri, 09 Sep 2016 07:29:32 GMT

mentioned on the sheet like jul-16,aug-16 could u plx tell me how to accomplish this kind of data