topic Re: How can I remove garbage values from Table in QlikView

How can I remove garbage values from Table

syedzee — Sat, 16 Nov 2024 01:11:53 GMT

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

Re: How can I remove garbage values from Table

lironbaram — Tue, 25 Feb 2020 12:25:50 GMT

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

Re: How can I remove garbage values from Table

syedzee — Wed, 26 Feb 2020 05:43:13 GMT

Hi,

How can i mitigate this issue ? Kindly guide

Thanks

Re: How can I remove garbage values from Table

Brett_Bleess — Thu, 26 Mar 2020 15:14:27 GMT

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