concatenating table with excel

[New-Qlik]

Hello ,

I am trying to concatenate a data base table with an excel contaminating 4 columns . On doing so month columns coming like this in output. 

jan 

feb

march

            jan

           feb

         march

etc .

anyone knows the reason.

In table i have put Month(date) as month

and in excel i have month column containing jan, feb,march etc. 

[Uday_Pasupuleti]

DId you try converting both columns by using Date(YourMOnthfield,'MMM') as Month ?

[iswarya · Accepted solution]

It's because they are in different format(I.e) String, Number