Hi all, I need again your help. I would like merge two tables together to make one new. I tried concatenate and outer join, but results wasnt right. I need make table where will be fields "Material", "Storage Bin" and "Date" from first one and "Available stock" from second one. From second one I can take "Date" from file name (date is part of file name).
And after I make it succesfully, in Qlik application I need make table, when I will see how many specific materials is on specific bin (it is location) in different days.
In added file is screen of table what I need. Only now I know, that I see wrong data inside. I tried make it throught new filed "Keyword", that is "Material" + "Storage bin". Second added file is screen of data model viewer, where I see field "Available stock" only with "-".
This is my attempt in dataload editor:
Data:
LOAD
@3 as TO,
@6 as Item,
@7 as Material,
@9 as TYP,
@10 as "Storage Bin",
@11 as PAr,
@16 as Qty,
@17 as "Mvt type",
@21 as ADate,
@7 &' '& @10 as Keyword
FROM [lib://TO/2017W??TO.txt]
(txt, codepage is 28591, no labels, delimiter is '|', msq, header is 5 lines);
Outer Join(Data)
LOAD
// Material,
// "Storage Bin",
"Available stock",
Material &' '& "Storage Bin" as Keyword
// Date(Floor(FileTime())) as ADate,
// FileTime()
FROM [lib://zlx/ZLX02S_2017????_05????.txt]
(txt, codepage is 28591, embedded labels, delimiter is '\t', msq);
