I am trying to load an excel in which one column has values separated by Spaces as below
Col A
Fire
Room
Dog
Yellow
Red
when i reload this data in qlikview its read as below for the cell in which there are 2 values Fire and Room , its fetching only first value ....i tried purgechar,ltrim,rtrim,trim ..but nothing seems to work.,
Its hard to tell exactly what your issue is without an excel file to examine. It looks like you don't means spaces. Are Fire and Room in the same cell on different lines? Is so, they are separated by a line feed.
