Claireball - Duplicates in Qlikview

Claireball - Duplicates in Qlikview

Clairebell experiences a recurring issue with their Qlikview reports. Duplicates are created in the system and are seen on their reports. This happens in the individual JAS DATA companies, so you need to run the fix in each DATA company individually. Follow the below instructions:

STEPS:

1. Open JAS in the required data company.

2. From the Utilities menu, open the Command Window. 

3. Write: do fixcustdiv

4. Notice the duplicates in the table that just opened. 

5. Hit the "escape" key. That will clear the table.

6. Close this window. 

7. Write : exit. That will close the command window


--> After completing the steps above in each Data company required inform Ed and he will complete the process.
(an example of this process is ticket #287)

    • Related Articles

    • Claire OTS Custom excel report

      Introduction The following wiki explains how to generate an Excel OTS report that will show pictures, print specs, or sort by body Setup In the main JAS menu, go to: File Alternate Menu In the alternate menu, go to: Styles Create Excel OTS Report ...

    • Fix File Structure Procedures

      Introduction The following wiki explains how to run a process called Fix File Structure in JAS.  This process is sometimes required to make sure that JAS programs and screens are using the most current data table structures. In order to ensure that ...

    • Fixing an Order that Crashed During Invoicing

      Table of Contents Introduction How Jonar can fix this Step 1: Verify the log Click on Fix Order Introduction It can occur where a user tries to invoice an order and received an error message due to a crash in the system. This can happen for a variety ...

    • Resolving the 'Problem with Journal File' Message

      Table of Contents: 1 - Introduction 2 - Resolving this message       Step 1: Renaming the files       Step 2: Run a fix file structure Introduction It can occur where users will receive the following message when trying to generate transactions in ...

    • Manual & Automatic Data Copy

      Table of Contents Introduction Manual Method  Step 1 : Go to Explore Step 2 : Locate JAS Step 3: Locate the folder where data will be placed Step 4: Run a Fix File Structure Automatic Method Step 1: Open JAS  Introduction These instructions can be ...