Data importing blank from Excel

[Daniel77]

Hi,

I am importing some data from Excel which is a number stored as text

This is loading into Qlik as blank for the whole column. the data in this field is a mix of numbers and letters.

e.g.

30C

3

W40L2XL

UK 18

ONE SIZE

M/L

I have tried to load this field as Num() and Text() and still blank on the import.

I have another column in the data which is formatted the same but all numbers and the data imports fine.

How can i load this data please?

Thank you

Happy Holidays!

[Diego_780]

Hi,

Can you upload maybe some of your script and how the working column is of your Excel?

[Daniel77]

Hi,

Thank you so much for the reply, apologies but the data is sesnitive and cannot be shared.

I have not experienced this before (the num importing as blank) 

Have you ever seen this?

Thanks again.