Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JMAROUF
Creator II
Creator II

Rename column dynamically in load editor

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;

Labels (1)
1 Solution

Accepted Solutions
MarcoWedel

maybe using a generic load?

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

 

MarcoWedel_0-1697489148679.png

 

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

 

View solution in original post

1 Reply
MarcoWedel

maybe using a generic load?

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

 

MarcoWedel_0-1697489148679.png

 

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