transformation

[nareshthavidishetty]

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 !

[varshavig12]

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

[varshavig12]

May be a sample of the output.

Current output and the desired one.

[susovan]

You can use this two tables through different excel sheet.

[Anil_Babu_Samineni]

See like this for 1st one?

[nareshthavidishetty]

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....

[teiswamsler]

hi nareshthavidishetty nareshthavidishetty

Its a complex excel.

You have to load the excel i stages.

Using the transform wizard and crosstable funktion.

/Teis

[varshavig12]

Try this.

[nareshthavidishetty]

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

[varshavig12]

for the second table where is the month ?