Rename column dynamically in load editor

JMAROUF — Mon, 16 Oct 2023 18:28:54 GMT

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;

Re: Rename column dynamically in load editor

MarcoWedel — Mon, 16 Oct 2023 20:48:00 GMT

maybe using a generic load?

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