Generated Table 2 don't show in the Sheet

[Zaidan_as]

When i'm loading a new data using load editor, there are no errors from it and it already completed 
this is the message from load editor

3:50:19 PM

Output cleared.

3:50:29 PM

---

Started loading data

---

Table1 << report_tickets

Lines fetched: 16,298

Table2 << report_tickets

Lines fetched: 2,894

data1 << report_tickets

Lines fetched: 19,192

data2 << report_tickets

Lines fetched: 19,192

report_tickets << report_tickets

Lines fetched: 19,192

Table1_temp_5f1aa24f-6489-8422-82a7-6dff2f75 << Table1

Lines fetched: 16,298

Table2_temp_3241bdd3-9cca-f0bb-3176-72a95d4c << Table2

Lines fetched: 2,894

Creating search index

Search index creation completed successfully

---

App saved

Finished successfully

0 forced error(s)

0 synthetic key(s)

Then when i go to edit the sheet, i look up to filter by table, there are no data2 table.

is this a bug or what ? 

Fyi, my data2 table using Join function from data1. This is the script 

data1 :
LOAD
Year(Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesCreated],
if(len(trim([Created Date]))>0,1,0) as [InVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

data2 :
Join(data1) LOAD
Year(Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesClosed],
if(len(trim([Closed Date]))>0,1,0) as [OutVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

[brunobertels]

Hi 

You may not have data2 available just because you join it with data1. 

if you want to retrieve source table ( Data1 Or Data2 source after joining add dimension 

Data1: 

'From data1' as SourceData,

...

From 

Data2 

join(data1) load 

'From data2' as SourceData, 

... 

From 

[Zaidan_as]

Sorry for late response,

So if you say that, my code will be like this : 

data1 :
LOAD
'From data1' as SourceData,
Year(Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesCreated],
if(len(trim([Created Date]))>0,1,0) as [InVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

data2 :
Join(data1) LOAD
'From data2' as SourceData,
Year(Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesClosed],
if(len(trim([Closed Date]))>0,1,0) as [OutVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

but after I load it, it still not showing the data2 table. Is there any wrong step or code from me ? 

[Zaidan_as · Accepted solution]

Ok i already found the answer, 

Right now I'm using this script :

data1 :
LOAD
'From data1' as SourceData1,
Year(Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Year(Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))&''&Num(Month((Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')))), '00') as [tesSort],
Timestamp(Timestamp#([Created Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesCreated],
[Plant] as [tesPlant],
if(len(trim([Agent Name]))=0,'No Agent',[Agent Name]) as [tesName Agent],
UPPER([Agent Group Name]) as [tesAgent Group Name],
if(len(trim([Created Date]))>0,1,0) as [InVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

data2 :
Left Keep(data1)
LOAD
Year(Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))&'-'&Month((Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')))) as [tesIn],
Timestamp(Timestamp#([Closed Date],'YYYY-MM-DD hh:mm:ss TT')) as [tesClosed],
[Plant] as [tesPlant],
if(len(trim([Agent Name]))=0,'No Agent',[Agent Name]) as [tesName Agent],
UPPER([Agent Group Name]) as [tesAgent Group Name],
if(len(trim([Closed Date]))>0,1,0) as [OutVal]
FROM [lib://FSDownload (sbm-vmqlik_qsadmin)/report_tickets.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

There are some additional code, but for the summary, I just change Join() to Left Keep() function.