4 Replies Latest reply: Nov 26, 2015 11:29 AM by Cesar Galiano RSS

    Complete empty fields with data from another table

    Cesar Galiano

      Hello everybody, I'm newby in Qlik and I'm facing this...

       

      I have a text file from a barcode scanner, it gives me one row for each item lecture, but for some items it gives me the EAN (some type of item number) and for some other it gives me Internal item ID's.

      Something like:

       

      EAN1

      ItemID1

      EAN2

      ItemID2

      ItemID3

      ItemID4

      ...

      I'm able to distinguish both type of lines thats no problem

       

      I have to cross it with another table in wich I have Internal ID's form all the articles.

       

      I want to cross the text file with my database where I have a table with all EANs and Internal ID's to get one single table with the Internal article ID's from the scanner lecture.

       

      ItemID1

      ItemID2

      .....

       

      Could you help me with the script?