Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have an issue in the data load editor, where I'm trying to left join Table2 on Table1.
my code says:
data_for_export:
noconcatenate LOAD
field1,
field2,
value
resident Table1;
left join LOAD
field1,
totalSample
resident Table2;
So I would expect a table with field1, field2, value, totalSample
However, the totalSample is blank (it's added as a field, but it's blank).
note that there are in fact a lot more fields and many values are blank, but I don't think this matters?
I looked at the tables from every different angle, but I'm absolutely clueless
When I export both tables to txt, drop both and then do the EXACT same load from the csv's, everything goes well and the totalSample is added correctly.
This leads me to believe that it's not the method that is wrong, but something internal to qlik sense?
Does anyone have a clue? Is it because I have so many blanks? Is it because there's a synthetic keys between the tables?
Exporting resident tables, dropping them and uploading them again is slow but most of all sloppy. I would really like to know what causes the error.
Thanks in advance,
Mikis
In your example the empty fields are blank values, not null values.
-Rob