remove col and row in cross table of wizard

[wenkew186]

hi expert,

I have a question want study from you.

when we load data from a excel table. I don't need all column to qvw file, there have a 2 method for my understand.

first, remove column by transformation step in "File wizard"; second, just keep useful column name in load script.

what's the different or not? my focus on if well impact memory in qvw or load efficiency.

thanks a lot!

[arvind_patil]

Hi Kevin,

If  you take required columns  then it will improve your performance because its in memory tool.  Its Store your all data  on server memory means less data less memory.

Thanks,

Arvind Patil