Can anyone help tell me why my load script wont work?

[#1]

I am trying to add a section to my load script to help me generate the Canonical Date reference. I followed along with the blog post and I think I have an idea how it should work but when I try to load my data it errors out every time.

What I have tried to load is shown below, any help would be greatly appreciated as I am struggling to understand how the scripting language works within Qlik Sense:

[QLIK report -No Incomplet]:
LOAD
[Application Number],
[First Active Date],
[First Completed Date],
[First Withdrawn Date],
[First Cancelled Date]
 
FROM [lib://QLIK Data/QLIK_report.xlsx]
(ooxml, embedded labels, table is [QLIK report -No Incomplet]);

DataBridge:
Load [Application Number],[First Application Submitted Date] as CanonicalDate,
Resident DateTable;
      
Load [Application Number],[First Active Date] as CanonicalDate,
Resident DateTable;
  
Load [Application Number],[First Completed Date] as CanonicalDate,
Resident DateTable;
        

[undergrinder]

Hi Paul,

As I see you have an extra comma ' , ' at the last columns of resident tables.

DataBridge:

Load [Application Number],[First Application Submitted Date] as CanonicalDate ,  <-this is the extra comma

Resident DateTable;

G.

[reddy-s]

Hi Paul,

Get rid of the ',' to the end of the last field in the load statements.

Thanks,

Sangram.

[#4]

So here is the script I am currently running. I made it smaller so that I can figure out why things are not working the way I think they should. So now I am just looking at two date fields that I would like to merge as a single timeline. But I am still getting the Synth Key for some reason... I guess I need to find some more training material to figure out how general scripts are supposed to be formatted/written.

[DateTable]:
LOAD
[Application Number],
[First Application Submitted Date],
[First Completed Date]
 
FROM [lib://QLIK Data/QLIK_report.xlsx]
(ooxml, embedded labels, table is [QLIK report -Solar No Incomplet]);

DataBridge:

Load [Application Number],[First Application Submitted Date] as CanonicalDate

Resident DateTable;

Load [Application Number],[First Completed Date] as CanonicalDate

Resident DateTable;

[jagan]

Hi Paul,

There is nothing wrong in this script.  What error you are getting?  Can you attach screenshot.

Regards,

Jagan.

[#6]

This is what I get returned to me after loading my data...