Rename column dynamically in load editor

[JMAROUF]

Hi,

I'm looking to load my columns as follow:

a:
LOAD *,LIB as '$(mid(LIB,3))' INLINE [
ID,LIB
1,lib1
1,lib11
2,lib2
3,lib3
];

it's possible?

thanks;

[MarcoWedel · Accepted solution]

maybe using a generic load?

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...

a:
Generic
LOAD *, mid(LIB,3), LIB INLINE [
ID,LIB
1,lib1
1,lib11
2,lib2
3,lib3
];