Load empty columns out of xlsx

[kris_vliegen]

I have an xlsx where there is data from column A till column AR.

In the future there can be data till column BE.

So I will load all columns till AE in Qlikview.

If I do 'Data from data files' and select my xlsx and the correct tab then I see only till column AW.

If I put values in columns AX till BE I see the columns for adding in the script.

Bur if those are empty it's only till AW. How can I load the columns AX till BE even if there is no data in.

Who knows how I can load the empty columns?

[rubenmarin]

Hi, I'm not sure to understand the question... that's only a wizard that helps to create the script, you can edit the script to add all the needed columns.

You can also add dummy data on the expected columns that will have data just to have a template to use to automatically create the script for all columns and not have to write them.

When the excel is read, if there is no data in those additional columns it won't return any error, those will be just empty fields

[Oleg_Troyansky]

How about loading all available columns using the asterisk:

LOAD *

FROM ... 

This way, whenever new data gets added in the future, the script will always pick it up? You just need to ensure that column labels are specified in the way you want to see them in the App.

Cheers,

Oleg Troyansky

[kris_vliegen]

Thanks,

this is working, only I need to do some calculations with it and now the sorting is not correct anymore.

I need to create a new xls but in order from A to Z.

Now the column A, M and N are at the end and not at the alphabetical place.

Someone who knows how to sort this?

[marcus_sommer]

I would try to use a single load-statement - just simply written down or with defining it with n variables. Something in this way:

set f1 = "if(..., ..., ...) as A";
set f2 = "B, C, D, E, F, G, H, I, J, K, L";
set f3 = "if(M = ..., ..., ...) as M, if(N = ..., ..., ...) as N";
set f4 = "O, P, ..........";

t: load recno() as X, $(f1), $(f2), $(f3), $(f4) from xlsx;

and afterwards may come a renaming with a mapping.