Complete empty fields with data from another table
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.
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.