Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
is this a bug or what ?
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);
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.
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
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 ?
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.