How can I remove garbage values from Table

[syedzee]

Hi,

I'm facing issue in table. Table is showing garbage value 0,1,2,3 etc but in my excel file there is no such value exist.

How can i remove these values.

Table snapshot is attached for reference.

Excel file data look like

Customer_Id, Period, Alert

1                         1               Credit card payment missing

Thanks

[lironbaram]

hi 

usually that happens when you have , as part of the value in the table 
so when qlik read the data it splits the field 

[syedzee]

Hi,

How can i mitigate  this issue ? Kindly guide

Thanks

[Brett_Bleess]

Likely need to attach a sample Excel file and QVW file so folks can look into things in more detail, rather difficult to say for sure otherwise, would be guessing at best...

Regards,
Brett