Force create Table column names

[lahiru_ten]

Hi All,

I’ve got a workflow that processes an excel document to the form I want. The excel document already has data in it but I want to run the same workflow on a blank excel document. The problem I have is Power BI throws error messages as the new columns from the pivot process don’t exist so the measures and graph visuals will show errors as well. Is there a way for KNIME to force itself to create those columns?

I’ve attached the full workflow - the area I’m focused on is the record drawing section where I’ve currently got a version with populated data. I’ve uploaded the excel tracker with no data.

Dashboard.knwf (666.9 KB)

GBL-0473-XX-XX-SH-X-200008 Record Drawing Schedule No Data.xlsx (161.3 KB)

Any help will be greatly appreciated. If you have any comments on improving efficiency of the workflow in full, I’ll happily take on the advice as this my first proper workflow.

Regards

Lahiru

[sjporter]

Hey @lahiru_ten,

If I understand your question correctly, you can likely achieve what you want by using the Table Creator node to define all of the columns you expect to see and then passing the output of the Table Creator node as well as the Excel Reader output into a Concatenate node. This will add all of the fields from the Table Creator node to the empty Excel Reader output.

The workflow might look something like this:

Example Table Creator node config (please note that I am specifying columns only - no data):

Output from the Concatenate node in my example workflow:

Hope this helps, and good luck!

Cheers,

@sjporter