Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
"A as B" that should be the easy way to rename right???
So why does this not work:
LOAD Name1,
Name2,
Name3,
Name4 as NameA,
if(NameA <50, '<50', if(Name A <100, '<100', if(Name A <5000, '<5000'))) .... as Example,
Name5,
Name 6,
....
....
Without "...as NameA", that is just using Name4 works fine.
Super, it seems to work 🙂
Though it did not like the "Dtop table", false statement, what does it do?
The command is DROP Table tablename
Drop Table
One or several QlikView internal tables can be dropped from memory at any time during script execution,
by means of a drop table statement. The following items will be lost as a result of this:
l The actual table(s).
l All fields which are not part of remaining tables.
l Field values in remaining fields, which came exclusively from the dropped table(s).
The syntax is:
drop table[ s ]tablename [, tablename2 ...]
lol, I need glasses, how could I miss. thx again, I am out of helpful answers at this point.
So I guess I should do this, so I don't fill up the memory twice!
Works
It seems easier, but I am not sure whether it is more correct than Gerrit's solution...
Should I use DROP here?
You Edit it, right